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.

How to get table schema with there indexes

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)