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.

See Also