sql server 数据库 查询数据库中所有的表和表对于的列名

SELECT
TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_SCHEMA = 'dbo'
ORDER BY
TABLE_NAME, ORDINAL_POSITION;