请教条查询关联名称的sql语句
我添加个表关联,
alter Table IDP_DomainRelation add constraint PK_DomainO foreign key(Name)
请问下怎样把 constraint 的名称 "PK_DomainO "通过sql语句查出来呢?
[解决办法]
http://blog.csdn.net/sxycgxj/archive/2005/09/29/492208.aspx
[解决办法]
select * from sysobjects where xtype= 'f ' and parent_obj=object_id( 'IDP ')
[解决办法]
SELECT a.name AS PK, b.name AS NAME
FROM sysobjects a INNER JOIN
sysobjects b ON a.parent_obj = b.id
WHERE (a.xtype = 'pk ') AND b.name = 'IDP_DomainRelation '
[解决办法]
学习.
[解决办法]
学习
