Declare @Table VARCHAR(100) Declare @Column VARCHAR(100) --這裡接收表名及字段名 SET @Table='表名' SET @Column='字段名' IF Len(@Table)>0 AND Len(@Column)>0 Begin set @Table='dbo.' + @Table select object_name(constid) Constraint_Name from sysconstraints sc join syscolumns sm on sc.id = sm.id and sc.colid = sm.colid where sc.id = object_id(@Table) and sm.name =@Column and sc.status | 5 = sc.status END