Search This Blog

Thursday, March 17, 2011

how to find primary keys for particular server and particular Data Base

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'"

No comments:

Post a Comment