sys.fulltext_catalogs (Transact-SQL)
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)
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho