Select all columns from all tables in the database

SEARCH

THIS WEEK'S MOST VIEWED ARTICLES

admin
19.06.2009

If you want to see all the columns and their properties write the following SQL command in SQL Studio Management: SELECT * FROM INFORMATION_SCHEMA.COLUMNS You can filter the results by table name, data type, collation, etc.

This is relevant for …

Sql server

Post a comment