Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Applies to: 
SQL Server
Azure SQL Managed Instance
Contains a row for each full-text catalog.
Note
The following columns will be removed in a future release of SQL Server: data_space_id, file_id, and path. Do not use these columns in new development work, and modify applications that currently use any of these columns as soon as possible.
| Column name | Data type | Description |
|---|---|---|
| fulltext_catalog_id | int | ID of the full-text catalog. Is unique across the full-text catalogs in the database. |
| name | sysname | Name of the catalog. Is unique within the database. |
| path | nvarchar(260) | Name of the catalog directory in the file system. |
| is_default | bit | The default full-text catalog. True = Is default. False = Is not default. |
| is_accent_sensitivity_on | bit | Accent-sensitivity setting of the catalog. True = Is accent-sensitive. False = Is not accent-sensitive. |
| data_space_id | int | Filegroup where this catalog was created. |
| file_id | int | File ID of the full-text file associated with the catalog. |
| principal_id | int | ID of the database principal that owns the full-text catalog. |
| is_importing | bit | Indicates whether the full-text catalog is being imported: 1 = The catalog is being imported. 2 = The catalog is not being imported. |
Permissions
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission.
See Also
Catalog Views (Transact-SQL)
CREATE FULLTEXT CATALOG (Transact-SQL)
ALTER FULLTEXT CATALOG (Transact-SQL)
DROP FULLTEXT CATALOG (Transact-SQL)