- 1 year ago
Rebuild Full Text Catalog with new Name
Comment
1 / 1
To rebuild a Full-Text Catalog with a new name, you can follow these steps:
Remove the current Full-Text Catalog using the DROP FULLTEXT CATALOG statement in SQL Server Management Studio or by executing a query in SQLCMD.
Example:
cssDROP FULLTEXT CATALOG [MyCatalog];
Create a new Full-Text Catalog with the desired name using the CREATE FULLTEXT CATALOG statement.
Example:
sqlCREATE FULLTEXT CATALOG [NewCatalog] WITH ACCENT_SENSITIVITY = ON;
Define the Full-Text Index using the new Full-Text Catalog.
Example:
cssCREATE FULLTEXT INDEX ON [dbo].[MyTable] ([MyColumn])
KEY INDEX [PK_MyTable] ON [NewCatalog];
Note: Make sure to backup the Full-Text Catalog before making any changes to it.