Online Documentation for SQL Manager for SQL server

Full-Text Catalogs

Full-text catalogs and Full-text indexes are the objects that are implemented in Microsoft® SQL Server for efficient full-text administration which is carried out at the server, database, table and column levels.


Like regular indexes, Full-text indexes can be automatically updated as data are modified in the associated tables. Index updating is normally performed as an asynchronous process that runs in the background during periods of low database activity. Tables with the same update characteristics (e.g. small number of changes and large number of changes) should be grouped together and assigned to the same Full-text catalog.


One Full-text catalog can have several full-text indexes, but a full-text index can only be part of one full-text catalog.



Full-Text Catalog Editor allows you to define full-text catalog properties. It opens automatically when you create a new full-text catalog and is available on editing an existing one.


To open a full-text catalog in Full-Text Catalog Editor, double-click it in the DB Explorer tree.