Fulltext index in sqlserver 2008
-
Hi, I have problem where I have get list of all tables on which full text index can be applied with their key names. Please help, its urgent. Thanks.
-
Hi, I have problem where I have get list of all tables on which full text index can be applied with their key names. Please help, its urgent. Thanks.
awadhendra tiwari wrote:
I have problem where I have get list of all tables on which full text index can be applied with their key names.
SELECT TC.[TABLE_SCHEMA]
, TC.[TABLE_NAME]
, CCU.[COLUMN_NAME]
, TC.[CONSTRAINT_NAME]
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS TC
JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE CCU ON TC.[CONSTRAINT_NAME] = CCU.[CONSTRAINT_NAME]
WHERE TC.[CONSTRAINT_TYPE] = 'PRIMARY KEY'
AND EXISTS (
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS C
WHERE C.[TABLE_NAME] = TC.[TABLE_NAME]
AND C.[DATA_TYPE] IN (
'char',
'varchar',
'nchar',
'nvarchar',
'text',
'ntext',
'image',
'xml',
'varbinary',
'varbinary(max)'
)
)
ORDER BY TC.[TABLE_NAME]awadhendra tiwari wrote:
its urgent
The people that visit this site do so in their spare time. Rushing would be inappropriate.
I are Troll :suss: