Select all columns from all tables in the database | Softescu | Full Service Digital Agency for Drupal & Mobile in Romania

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

CAPTCHA

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