Get list of all table name along with their column name

The following MS SQL query can be used to get list of tables along with their column details.

SELECT * FROM INFORMATION_SCHEMA.COLUMNS

Source : MSDN Forum

Leave a Reply

Your email address will not be published / Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.