Something like this:
SELECT
*
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE CONSTRAINT_NAME ='FK_TreeNodesBinaryAssets_BinaryAssets'
and TABLE_NAME = 'TreeNodesBinaryAssets'
but for indexes.
-
1010 Avenue of the Moon
New York, NY 10018 US. -
Mon - Sat 8.00 - 18.00
Sunday: Closed - Get A Quote
How do you check if a certain index exists in a table?
- IT Nursery
- May 14, 2022
- 0