1,SQL SERVER
根据表明查询表结构
select name from syscolumns where id=object_id('caigou')
根据表明查询表结构及数据类型
Select a.name as colname,b.name as typename
from syscolumns a,systypes b where a.xusertype=b.xusertype
and a.id=object_id('caigou')
2,ORACLE
根据表明查询表结构
select * fromuser_col_comments t where t.table_name='CAIGOU'
根据表明查询表结构及数据类型
SELECT * FROMuser_tab_columns WHERE table_name = 'CAIGOU'