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
Comments
Post a Comment