When I view the schema for my table, I can tell by the commands I see in the bottom panel that it isn't even trying to load the indices (except for primary keys). Is this a known limitation? If so, can you at least put something in the "Indexes" tab that says "this list of indexes is incomplete"?
Heidi SQL doesn't even try to load indexes from SQL Server
What about getting the other keys into the list? Can you provide some SQL snippet which gives indexes in such a list:
* [CONSTRAINT_NAME1], [CONSTRAINT_TYPE], [COLUMN_NAME1]
* [CONSTRAINT_NAME1], [CONSTRAINT_TYPE], [COLUMN_NAME2]
* [CONSTRAINT_NAME2], [CONSTRAINT_TYPE], [COLUMN_NAME3]
* [CONSTRAINT_NAME3], [CONSTRAINT_TYPE], [COLUMN_NAME4]
* [CONSTRAINT_NAME1], [CONSTRAINT_TYPE], [COLUMN_NAME1]
* [CONSTRAINT_NAME1], [CONSTRAINT_TYPE], [COLUMN_NAME2]
* [CONSTRAINT_NAME2], [CONSTRAINT_TYPE], [COLUMN_NAME3]
* [CONSTRAINT_NAME3], [CONSTRAINT_TYPE], [COLUMN_NAME4]
For constraints INFORMATION_SCHEMA.TABLE_CONSTRAINTS can be used:
SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
for indexes there are some queries can be used here: search for list-of-all-index-index-columns-in-sql-server-db on stackoverflow (sorry couldn't share the exact link)
Both for SQL Server (>= 2005) only.
Please login to leave a reply, or register at first.