Wednesday, February 24, 2016

How do you check if a certain index exists in a sql server table?

IF EXISTS(SELECT * FROM sys.indexes WHERE name='[IndexName]' AND object_id = OBJECT_ID('[Schema].[Table]'))
BEGIN
    --statements
END

No comments:

Post a Comment