 |
 |
Idle Banter For non SV and non bike related chat (and the odd bit of humour - but if any post isn't suitable it'll get deleted real quick). There's also a "U" rating so please respect this. Newbies can also say "hello" here too. |
 |
|
|
Thread Tools |
26-10-11, 05:00 PM
|
#1 |
|
Member
Mega Poster
Join Date: Mar 2010
Location: Mid Wales
Posts: 2,691
|
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..... |
|
|
|
26-10-11, 05:41 PM
|
#2 |
|
Member
Join Date: Aug 2010
Location: shropshire
Posts: 133
|
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 |
|
|
|
|
26-10-11, 06:09 PM
|
#3 |
|
Member
Mega Poster
Join Date: Mar 2010
Location: Mid Wales
Posts: 2,691
|
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! 
|
|
|
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Off road bike events: definitions | thor | Bikes - Talk & Issues | 3 | 14-12-06 02:09 PM |
| REAL-WORLD Tool Definitions | Supervox | Idle Banter | 2 | 19-05-06 01:33 PM |
| SQL Server Schema viewer? | timwilky | Idle Banter | 10 | 14-04-06 06:11 AM |
| *Real World* Tool Definitions | Supervox | Idle Banter | 4 | 07-04-06 12:19 PM |
| Off road bike events: definitions | scott58 | Idle Banter | 2 | 09-01-70 06:40 AM |
