数据库表结构查询

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'