SQL得到数据库的字段类型,及长度

用视图

select A.object_ID,A.name as tablename,
B.name as columnname,c.name as typename,
b.max_length,b.scale
from sys.all_objects a,Sys.columns B,sys.types C
where a.object_ID = b.object_ID
and b.system_type_ID = c.system_type_ID
and a.type='U'
order by tablename 

用表访问

select A.ID,A.name as tablename,
B.name as columnname,c.name as typename,
b.length,b.xscale
from DBO.sysobjects a,DBO.Syscolumns B,DBO.systypes C
where a.ID = b.ID
and b.xtype = c.xtype
and a.type='U'
order by tablename

 

ORACLE

SELECT column_name,data_type,data_length,data_Precision,Data_Scale FROM all_tab_columns WHERE table_name="表名"