Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Using Transact-SQL Functions to Obtain Full-text Property Values

Using Transact-SQL Functions to Obtain Full-text Property Values

SQL Server 2000

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

See Also

COLUMNPROPERTY

DATABASEPROPERTY

DATABASEPROPERTYEX

FULLTEXTCATALOGPROPERTY

FULLTEXTSERVICEPROPERTY

INDEXPROPERTY

OBJECTPROPERTY

Show:
© 2015 Microsoft