如何查看建立的约束（constraint）

Question

RT，不过要用T-sql语句查看的
就是说：
create table Course(
Cno char(10),
Cname char(10) constraint Cname_bind not null,
C smallint,
constraint Cno_bind check(Cno between 1 and 1000),
constraint C_bind check(C between 0 and 7)
)
新建了一个表，然后想用语句如何可以查看我所建的约束呢？

Answer 1

SELECT * FROM SYS.CHECK_CONSTRAINTS

Answer 2

如果是看单个表的话
Name                                                                                                                             Owner                                                                                                                            Type                            Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
Course                                                                                                                           dbo                                                                                                                              user table                      2009-12-12 15:41:52.263 
 
Column_name                                                                                                                      Type                                                                                                                             Computed                            Length      Prec  Scale Nullable                            TrimTrailingBlanks                  FixedLenNullInSource                Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
Cno                                                                                                                              char                                                                                                                             no                                  10                      yes                                 no                                  yes                                 Chinese_PRC_CI_AS
Cname                                                                                                                            char                                                                                                                             no                                  10                      no                                  no                                  no                                  Chinese_PRC_CI_AS
C                                                                                                                            smallint                                                                                                                         no                                  2           5     0     yes                                 (n/a)                               (n/a)                               NULL 
Identity                                                                                                                         Seed                                    Increment                               Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
No identity column defined.                                                                                                      NULL                                    NULL                                    NULL 
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined. 
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY 
对象 'COURSE' 没有任何索引，或者您没有所需的权限。
 
constraint_type                                                                                                                                    constraint_name                                                                                                                  delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
CHECK on column C                                                                                                                              C_bind                                                                                                                       (n/a)         (n/a)         Enabled        Is_For_Replication     ([C]>=(0) AND [C]<=(7))
CHECK on column Cno                                                                                                                                Cno_bind                                                                                                                         (n/a)         (n/a)         Enabled        Is_For_Replication     ([Cno]>=(1) AND [Cno]<=(1000)) 
没有外键引用表 'COURSE'，或者您没有引用表的相关权限。
Table is referenced by views
--------------------------------------------------------------------------------------------------------------------------------

Answer 3

。没粘上语句， 不好意思create table Course(
Cno char(10),
Cname char(10) constraint Cname_bind not null,
C smallint,
constraint Cno_bind check(Cno between 1 and 1000),
constraint C_bind check(C between 0 and 7)
) 
EXEC SP_HELP COURSE

Answer 4

EXEC SP_HELP COURSE列信息索引信息约束信息外键信息都有

Answer 5

exec sp_helpconstraint 'Course'

Answer 6

如果想查看单个约束的内容需要约束名EXEC SP_HELPTEXT 'Cno_bind'