-- Enable fulltext searching on the database USE database1; GO EXEC sp_fulltext_database 'enable'; GO -- Create a fulltext catalog CREATE FULLTEXT CATALOG ft_catalog_database1 GO CREATE FULLTEXT INDEX ON database1.dbo.poems ( title--->Column name Language 0X0, poem----->Column name Language 0X0 ) KEY INDEX PK__poems__00551192 ON ft_catalog_database1 WITH CHANGE_TRACKING AUTO; here PK__poems__00551192---->its index key
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)