RSS

Get Primary key of a table in SQL

18 Oct

By the following query you will get column name of table in current database.

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE WHERE TABLE_NAME = ‘Table_Name’

 
Leave a comment

Posted by on October 18, 2012 in SQL

 

Leave a comment