Particular Server :
EXEC
sp_primarykeys
Particular DB ::
select * from INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_TYPE='PRIMARY KEY' 'servername' sp_Msforeachdb "SELECT * FROM ?.INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_TYPE='PRIMARY KEY'"
EXEC
sp_primarykeys
Particular DB ::
select * from INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_TYPE='PRIMARY KEY' 'servername' sp_Msforeachdb "SELECT * FROM ?.INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_TYPE='PRIMARY KEY'"
No comments:
Post a Comment