0

Is there a way to check if an index exists in another database?

AFAIK, the usual ways (sys.indexes and INDEXPROPERTY) only run in the context of the current database.

1 Answer 1

3

Simply check the sys.indexes from another DB, same as you would with any other table.

SELECT *
FROM MyOtherDb.sys.indexes
WHERE name = 'MyIndex'

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.