Using Transact-SQL Functions to Obtain Full-text Property Values
Several Transact-SQL functions can be used to obtain the values of full-text properties. For example, the TableFulltextKeyColumn property can be used to programmatically obtain the identity of a unique key column for a table. Also, the IsFullTextEnabled property can be used to check whether full-text querying is enabled for a database. This example checks to see whether full-text querying is enabled for the Northwind database.
USE Northwind
GO
SELECT DATABASEPROPERTY('Northwind', 'IsFullTextEnabled')
If a value of 1 is returned, the Northwind database has been enabled for full-text querying. A value of 0 indicates that the Northwind database has not been enabled for full-text querying.
The table contains a complete list of properties. It should be noted that many of these properties are useful only for full-text administration.
| Function | Property |
|---|---|
| COLUMNPROPERTY | IsFulltextIndexed |
| DATABASEPROPERTY | IsFulltextEnabled |
| DATABASEPROPERTYEX | IsFulltextEnabled |
| INDEXPROPERTY | IsFulltextKey |
| OBJECTPROPERTY | TableFulltextBackgroundUpdateIndexOn |
| TableFulltextCatalogId | |
| TableFulltextChangeTrackingOn | |
| TableFulltextKeyColumn | |
| TableFulltextPopulateStatus | |
| TableHasActiveFulltextIndex | |
| FULLTEXTCATALOGPROPERTY | PopulateStatus |
| ItemCount | |
| IndexSize | |
| UniqueKeyCount | |
| LogSize | |
| PopulateCompletionAge | |
| FULLTEXTSERVICEPROPERTY | ResourceUsage |
| ConnectTimeout | |
| IsFullTextInstalled |