Posts Tagged ‘SELECT’

Select all columns from all tables in the database

Friday, June 19th, 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.