select name from sysobjects where xtype='u'
select name from linkserver.dbname.dbo.sysobjects where xtype='u'
select * from INFORMATION_SCHEMA.TABLES
select name from linkserver.dbname.dbo.sysobjects where xtype='u'
select * from INFORMATION_SCHEMA.TABLES
FROM 库名.INFORMATION_SCHEMA.TABLES where table_type='base table'
所有的用户表
所有表