Select all columns from all tables in the database

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.

Tags: ,

Leave a Reply