getting the check constrains of a field in an specific table

• ofern

  Old Hand

  Points: 399

  More actions

  January 28, 2005 at 11:56 am

  #65517

  I have a program to document a sql database , part of the program is using select to the SCHEMA and part of it is using DMO, table structure with field types, lenght , and so on , i am using the select against the schema but it seems that the checks are not store there, I am forced to use DMO.

  But DMO slowes the process, at least at my programming environment VFP9

  so I wonder if you guys know how to get the checks constarins of a field using t-sql?

• PW-201837

  SSC-Insane

  Points: 20805

  More actions

  January 28, 2005 at 12:08 pm

  #539599

  Check constraints are applied at the Table level:

  Select ctu.TABLE_NAME, cc.CHECK_CLAUSE

  From INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE as ctu

  Join INFORMATION_SCHEMA.CHECK_CONSTRAINTS as cc

    on (ctu.CONSTRAINT_CATALOG = cc.CONSTRAINT_CATALOG and

        ctu.CONSTRAINT_SCHEMA  = cc.CONSTRAINT_SCHEMA  and

        ctu.CONSTRAINT_NAME    = cc.CONSTRAINT_NAME)