/***************************关键词******************************
1、获取所有用户表
(1)SQL Server数据库:select name as Name from sysobjects where xtype = 'U' and name != 'dtproperties' order by Name
(2)Oracle数据库:select table_name as Name from user_all_tables order by Name
(3)DB2数据库:select Name from sysibm.systables where CREATOR = '登录用户' AND TYPE = 'T' order by Name
2、获取指定表的所有字段信息
(1)SQL Server数据库:select a.name as Name from syscolumns a inner join sysobjects b on a.id = b.id where b.name = '表名' order by Name
(2)Oracle数据库:select column_name as Name from user_tab_columns where table_name = '表名' order by Name
(3)DB2数据库:select Name from sysibm.syscolumns where TBName = '表名' order by Name