Wednesday 18 July 2012

how to find constraint of a table.

SELECT        COLUMN_NAME, CONSTRAINT_NAME
FROM            INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE        (TABLE_NAME = 'AMS_AssetList')

No comments:

Post a Comment