Select all columns from all tables in the database | Softescu | Full Service Digital Agency for Drupal & Mobile in Romania
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

CAPTCHA

We do not want to offend your intelligence so please pass this simple test to prevent automated spam submissions and Galactic Empire soldiers.