Share via


Inquiring About the Full-Text Key Column

To determine whether the regular Microsoft SQL Server index on the Document table in the Adventure Works database is used to enforce the uniqueness of the full-text key column, run the following statement:

  1. Run this statement:

    USE AdventureWorks
    GO
    SELECT INDEXPROPERTY ( OBJECT_ID('Production.Document'), 'PK_Document_DocumentID',  'IsFulltextKey' )
    

    This returns a value of 1 if the index is used to enforce uniqueness of the full-text key column, and 0 if it does not.

  2. To find the identifier of the full-text key column in the Document table execute this statement:

    USE AdventureWorks;
    GO
    SELECT OBJECTPROPERTYEX(OBJECT_ID('Production.Document'), 'TableFulltextKeyColumn');
    GO
    

See Also

Other Resources

FULLTEXTSERVICEPROPERTY (Transact-SQL)
sp_configure (Transact-SQL)
OBJECTPROPERTYEX (Transact-SQL)
sp_fulltext_service (Transact-SQL)
INDEXPROPERTY (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance