-Showing Table Constraints Order By TableName

Jayakumars
Posted by Jayakumars under SQL Server category on | Points: 40 | Views : 1294
9.--Showing Table Constraints Order By TableName--
Select CONSTRAINT_CATALOG as DbName,CONSTRAINT_NAME,TABLE_NAME,CONSTRAINT_TYPE
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS ORDER BY TABLE_NAME

Comments or Responses

Login to post response