SQL Server中使用SQL语句查询某表的所有字段及数据类型

Posted on | Post modified: | Visitors:

SQL Server中使用SQL语句查询某表的所有字段及数据类型

1
2
3
4
5
6
SELECT  name AS column_name ,
        TYPE_NAME(system_type_id) AS column_type ,
        max_length ,
        is_nullable
FROM    sys.columns
WHERE   object_id = OBJECT_ID(N'customerbase')  --customerbase 为表名