September 2, 2004 at 4:53 pm
I am attempting to verify non clustered indexes that I'm going to drop and recreate in another filegroup and having a very hard time weeding out the Primary Key and Check constraints out of sysindexes.
The sysconstraints table is exactly what I need to do this. Unfortunately the status that tells me 1 is a primary key or 4 is a check constraint is represented as a bitmap??????
How can I calculate which is which? Why does something which seems so simple have to be so difficult?
Sorry I'm an Oracle DBA trying to migrate into SQL Server and there's these frustrating little things I just don't understand.
September 2, 2004 at 5:44 pm
Check out the sysobjects table. Sysconstraints is a view on that table. You'll want to look at the xtype column in sysobjects (see Books OnLine for the list of xtype values).
I feel your pain. I went through the same thing when my agency starting moving from Oracle to SQL Server.
Greg
Greg
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply