楼主是什麼数据库,什麼版本;
MS SQL用
sysobjects/syscolumns/systypes三个连接就行了
以SQL2005也可用
select
a.Name as 表名,
b.Name as 列名,
c.Name as 类型,
b.max_length as 字节数,
b.Precision as 整数位,
b.Scale as 小数位
from Sys.tables a
inner join Sys.columns b on a.object_id=b.object_id
inner join sys.Types c on c.User_Type_ID=b.User_Type_ID
温馨提示:答案为网友推荐,仅供参考