Mega Code Archive

 

Categories / MSSQL Tutorial / System Tables Views

 

The sys fulltext_index_columns system catalog view lists all ull-text indexed columns in the database

3> 4> SELECT object_name(object_id) tblname, column_id 5> FROM sys.fulltext_index_columns 6> GO tblname          column_id ------------------------------------------------------------------------------------------------------------------------ -------- ----------- (0 rows affected) 1>