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 VIDEOS
 
 
SQL E/BOOKS   WORLD, USA & SQL NEWS   FORMAT
SCRIPTS SQL 2005 SQL 2008 ARTICLES
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
SQL 2016 DESIGN & PROGRAMMING
 
 
 
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