Export (0) Print
Expand All

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
    

Community Additions

ADD
Show:
© 2014 Microsoft