Post reply

Is there a sp for finding table constraints?

  • August 16, 2006 at 2:18 pm

    #94525

    Is there a sp for finding table constraints? I know in oracle U can use describe table and it will give the col,attribute, contraints, pk,fk ect...

    Looked on BOL did not find it.

     

    THANKS

  • August 16, 2006 at 2:23 pm

    #655339

    sp_help and sp_helpconstraint

     

  • August 18, 2006 at 5:42 am

    #655603

    You could also check out INFORMATION_SCHEMA views:

    --will give you a list of ALL constraints in the db

    SELECT * from INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE

    http://developer.mimer.com/documentation/html_91/Mimer_SQL_Engine_DocSet/Data_dic_views2.html

    is a starting place URL for INFORMATION_SCHEMA views.

    Keep in mind that for SQL2005, INFORMATION_SCHEMA views no longer exist as the system catalogue as we know it with SQL 7 & SQL 2000 are vastly different.

    Hope this helps!

    -Marti Ball

    MCP SQL 2000

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply