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

.....

*/