How to get table schema with there indexes

Question

hHow to get table schema with there indexes in sql server.????? Thanks in advance

Jeetendra Gund · Answer

it's getting pretty close to what you're looking for right? SELECT ind . name  ind . index_id  ic . index_column_id  col . name  ind .*  ic .*  col .* FROM sys . indexes ind INNER JOIN sys . index_columns ic ON ind . object_id = ic . object_id and ind . index_id = ic . index_id INNER JOIN sys . columns col ON ic . object_id = col . object_id and ic . column_id = col . column_id INNER JOIN sys . tables t ON ind . object_id = t . object_id WHERE ( 1 = 1 ) AND ind . is_primary_key = 0 AND ind . is_unique = 0 AND ind . is_unique_constraint = 0 AND t . is_ms_shipped = 0 ORDER BY t . name  ind . name  ind . index_id  ic . index_column_id try this link hope so http://stackoverflow.com/questions/765867/list-of-all-index-index-columns-in-sql-server-db

Jignesh Trivedi · Answer

hi i think there is no deirect way to find table schema and indexes together. sp_help and sp_helpIndex may help you. please refer http://www.razorsql.com/articles/ms_sql_server_admin_queries.html hope this will help you.