Enjoy Every Sandwich

Thoughts on SQL, XML, .NET and sometimes beer.

<January 2009>
SuMoTuWeThFrSa
28293031123
45678910
11121314151617
18192021222324
25262728293031
1234567


Navigation

Tools

List O'Links

Kent's Other Stuff

Subscriptions

News

Please read these
Notices and Disclamiers

Post Categories

Article Categories



Primary Keys and XML Indices: You can't have one without the other.

More of a note to myself: You can't create a XML Path Index without a primary XML Index, and you can't create a primary XML index without a primary key on the table. You also can't alter the columns in a Primary Key if you have an dependent XML index on the same table.

Of course, you can have a primary key without any XML indices, but that messes up my little mnenomic... :(

posted on Monday, January 24, 2005 8:28 PM by ktegels





Powered by Dot Net Junkies, by Telligent Systems