Retrieving Full-Text Catalog and Index Metadata : sys.fulltext_catalogs « System Tables Views « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. System Tables Views
  3. sys.fulltext_catalogs
46>
47> SELECT name, path, is_default, is_accent_sensitivity_on
48> FROM sys.fulltext_catalogs
49> GO
name
         path

                              is_default is_accent_sensitivity_on
------------------------------------------------------------------------------------------------------------------------
-------- ---------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
----------------------------- ---------- ------------------------

(0 rows affected)








27.5.sys.fulltext_catalogs
27.5.1.Retrieving Full-Text Catalog and Index Metadata