Assert verifies that index is a FULLTEXT index. Fail when index has not been found for a specified table or when table does not have full text index defined.

Note:
- Supported in SQL Server framework versions.
- Not all editions of SQL Server support full text indexes. 

Arguments

  • v_ObjectName – table or view name, SYSNAME
  • v_UserMessage – message to report when assertion fails, NVARCHAR(MAX)

Examples

 
SQL Server 

Below is assert that verifies filtered index created in the following statement:

CREATE TABLE FULLTEXT_INDEXTABLE(
   ID INT IDENTITY (1,1),
   TextCol1  VARCHAR(MAX),
   OtherCol INT,
   TEXT2 CHAR(200),
   CONSTRAINT PK_FULLTEXT_INDEXTABLE_on_ID PRIMARY KEY CLUSTERED (ID ASC)
);
GO

CREATE FULLTEXT CATALOG FULLTEXT_CATALOG;
GO

CREATE FULLTEXT INDEX
   ON FULLTEXT_INDEXTABLE(TextCol1)
   KEY INDEX PK_FULLTEXT_INDEXTABLE_on_ID
     ON FULLTEXT_CATALOG;

GO;

EXEC DBTD_ASSERT_INDEX_FULLTEXT 'FULLTEXT_INDEXTABLE', 'Issues with filtered index';

See Also