Heidi SQL doesn't even try to load indexes from SQL Server

[expired user #9420]'s profile image [expired user #9420] posted 8 years ago in General Permalink
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"?
ansgar's profile image ansgar posted 8 years ago Permalink
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]
[expired user #9442]'s profile image [expired user #9442] posted 7 years ago Permalink

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.