DATETIME SELECT SELECT INTO DATE PAD STRING DYNAMIC SQL CURSOR MONEY FORMAT PERCENT STORED PROCEDURE SQL SERVER AGENT JOB OPTIMIZATION WHILE LOOP OVER PARTITION BY UPDATE
SITE SEARCH SQLUSA.com HEADLINES NEWS
SQL E/BOOKS   SQL 2014 PROGRAMMING   DOWNLOADS
SCRIPTS SQL 2005 SQL 2008 ARTICLES
SQL JOBS TWITTER FORMAT VIDEOS
How to list the columns in all of the tables?

The following Microsoft SQL Server T-SQL query lists all tables with columns and datatypes using INFORMATION_SCHEMA views database metadata:

USE AdventureWorks2008;

 

SELECT   SchemaName = c.table_schema,

         TableName = c.table_name,

         ColumnName = c.column_name,

         DataType = data_type

FROM     information_schema.columns c

         INNER JOIN information_schema.tables t

           ON c.table_name = t.table_name

              AND c.table_schema = t.table_schema

              AND t.table_type = 'BASE TABLE'

ORDER BY SchemaName,

         TableName,

         ordinal_position

GO

/*

SchemaName  TableName         ColumnName        DataType

.....

Production  Illustration      ModifiedDate      datetime

Production  Location          LocationID        smallint

Production  Location          Name              nvarchar

Production  Location          CostRate          smallmoney

Production  Location          Availability      decimal

Production  Location          ModifiedDate      datetime

Production  Product           ProductID         int

.....

*/

 

Exam Prep 70-461
Exam 70-461
DATETIME SELECT SELECT INTO DATE PAD STRING DYNAMIC SQL CURSOR MONEY FORMAT PERCENT STORED PROCEDURE SQL SERVER AGENT JOB OPTIMIZATION WHILE LOOP OVER PARTITION BY UPDATE