sqlserver获得列名，列类型，列类型长度，scale，prec等数据类型（syscolumns，systypes，sysobjects均为视图） select a.name as colname, b.name as typename,a.length as length,a.scale as scale,a.prec as prec from syscolumns a,systypes b ,sysobjec
sqlserver获得列名，列类型，列类型长度，scale，prec等数据类型（syscolumns，systypes，sysobjects均为视图）
select a.name as colname, b.name as typename,a.length as length,a.scale as scale,a.prec as prec from syscolumns a,systypes b ,sysobjects c where a.xusertype=b.xusertype and a.id=c.id and c.name ='tablename' order by c.id
oracle获得列名，列类型，列类型长度，scale，prec等数据类型
select column_name,data_type ,data_length,data_precision,data_scale from user_tab_columns where   table_name='tablename'
sqlserver获得所有表名
select name from sysobjects where xtype='u'
oracle获取所有表名
select tname  from tab where tabtype='table'
获得表中主键的列，列类型，列类型长度
select a.name as colname, b.name as typename,a.length as length,a.scale as scale,a.prec as prec from syscolumns a,systypes b ,sysobjects c , information_schema.constraint_column_usage d where a.xusertype=b.xusertype and a.id=c.id and c.name ='tablename' and b.name'date' and a.name =d.column_name and d.constraint_name like 'pk_%'