SV650.org - SV650 & Gladius 650 Forum - Any database experts

SV650.org - SV650 & Gladius 650 Forum (http://forums.sv650.org/index.php)

- Idle Banter (http://forums.sv650.org/forumdisplay.php?f=116)

- - Any database experts - schema domain definitions? (http://forums.sv650.org/showthread.php?t=172135)

garynortheast

26-10-11 05:00 PM

Any database experts - schema domain definitions?

As above, any advice gratefully received.
When defining a primary key can I use varchar2 or does it need to be character with a defined range?
Thanks in advance.....

Fluffer

26-10-11 05:41 PM

Can indeed use a varchar2 as a pk - just so long as you have a way of ensuring stuff is unique when inserting you'll be pukka... Otherwise just messy dealing with constraint violations etc when compared to using an oracle sequence or sql server identity... Hth

Sent from my GT-I9100 using Tapatalk

garynortheast

26-10-11 06:09 PM

Re: Any database experts - schema domain definitions?

Lovely job, thanks for the answer.

When I finish this database module I hope never to have to deal with another database! :-(

All times are GMT. The time now is 02:03 AM.