获取表名称和字段类型
oracle :
select * from USER_TAB_COLUMNS where table_name = 'city_info';
sqlserver:
167 = varchar
select * from syscolumns where xtype = '167' and id in(select id from sysobjects where name = 'city_info' );
获取表名称和字段类型
oracle :
select * from USER_TAB_COLUMNS where table_name = 'city_info';
sqlserver:
167 = varchar
select * from syscolumns where xtype = '167' and id in(select id from sysobjects where name = 'city_info' );