Discussion in 'SQL Server 2005 General Developer Questions' started by a011010, Dec 22, 2009.
Hi,how can i found particular table's column has index or not
You could query the sys.index_columns to find out.
< pseudocode >
FROM sys.indexes I
JOIN sys.index_columns C ON ..
WHERE OBJECT_NAME(I.object_id) = < your table name >
</ pseudocode >
FYI you can refer to such basic information by looking at SQL Server Books Online (BOL) http://sql-server-performance.com/C...server/archive/tags/books online/default.aspx fyi
Separate names with a comma.