如何读取某个数据库有社么表

[Edwin2260]

请问如何显示某个数据库的数据库表

[愉快的登山者]

select name from sysobjects where xtype = 'u'

[sunsg]

select name from sysobjects where xtype = 'U'

[fengyuyan]

那如何得到所有的数据库呢

[8LY8Apollo]

select name from 数据库名..sysobjects where type = 'u' union all
select name from 数据库名..sysobjects where type = 'u' union all
select name from 数据库名..sysobjects where type = 'u' union all
select name from 数据库名..sysobjects where type = 'u' ……………………

[pengdali]

sp_tables
select * from INFORMATION_SCHEMA.TABLES
select * from sysobjects where xtype='U' and status>0

[pengdali]

exec sp_databases
select * from sysdatabases

[benxie]

楼上都可以。我也学习一下。