Archive for the ‘Constraint’ Category
How to find the Index fields of table in SQL Server
Posted by: admin in Constraint, Database on August 26th, 2010
Below is the query on finding the Index fields of the table
Returns Primary key
-
select * from sys.objects where parent_object_id = object_id(N'TABLE_1')
Returns All
-
SELECT * FROM SYS.index_columns where object_id= object_id(N'TABLE_1')