Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Index naming
Sat, Jan 20 2007 11:26 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Do index names now have to be unique within a database or is it still within a table?

Roy Lambert
Sun, Jan 21 2007 7:15 AMPermanent Link

Michael Baytalsky


> Do index names now have to be unique within a database or is it still within
> a table?
Why didn't you just test it? Wink


Michael

P.S. Yes it works, index names are unique within a table.
Sun, Jan 21 2007 9:36 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Michael


I was feeling lazy Smiley

Roy Lambert
Mon, Jan 22 2007 8:20 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< Do index names now have to be unique within a database or is it still
within a table? >>

Still within a table.  I believe the standard dictates that they are unique
within a schema, but I don't like particular rule for many reasons.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image