SQL查看所有表名：
1、select??? name??? from??? sysobjects??? where??? type='U'

2、select * from information_schema.tables

查询表的所有字段名：
Select name from syscolumns Where ID=OBJECT_ID('表名')

select * from information_schema.tables
select * from information_schema.views
select * from information_schema.columns

?

Oracle查看所有表名:select table_name from user_tables?

?

ACCESS查看所有表名：
select??? name??? from??? MSysObjects??? where??? type=1??? and??? flags=0
MSysObjects是系统对象，默认情况是隐藏的。通过工具、选项、视图、显示、系统对象可以使之显示出来

?

SQL查看所有表数据：

declare @sql nvarchar(100)
declare @tableName nvarchar(100)
declare cur cursor for
select name from sysobjects where xtype='U'? --搜索所有表名
open cur
while @@fetch_status=0
?begin
?? set @sql='select * from? [' + @tableName + '] '????? --循环查询表数据
?? exec sp_executesql @sql
?? fetch next from cur into @tableName
?end
close cur
deallocate cur
set nocount off

?