Mega Code Archive

 

Categories / MSSQL Tutorial / System Tables Views

 

Retrieving Full-Text Catalog and Index Metadata

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)