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