Thread: [admin] index in pk
hi all, there is a way to use my own index with pk constraint instead of the implicitly created one? why? just because i don't like the name, maybe can i change the generated name? thanx in advance, Jaime Casanova _________________________________________________________________ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail
On Wed, 7 Apr 2004, Jaime Casanova wrote: > hi all, there is a way to use my own index with pk constraint instead of the > implicitly created one? > why? just because i don't like the name, maybe can i change the generated > name? You should be able use the full version with the constraint naming clause: CONSTRAINT <name> PRIMARY KEY to make <name> the name of the index.
sorry if my questions are so primitive or show all my poor knowledge but ask is the way to find the right path. the dumber the question the smarter i will become. _________________________________________________________________ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail