![](https://i-blog.csdnimg.cn/blog_migrate/5f94c2fecb4ccb2f76f50c965d122407.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/50828477840f9be8f01bb82af691c7d1.gif)
exec sp_addlinkedserver 'linkserver','','SQLOLEDB','192.168.1.200' EXEC sp_addlinkedsrvlogin 'linkserver','false',NULL,'sa','123456' select * from linkserver.TestDB.dbo.TestTable Exec sp_droplinkedsrvlogin linkserver,Null Exec sp_dropserver linkserver
查询该数据库下所有表名称
SELECT NAME FROM linkserver.HXPortal.dbo.SYSOBJECTS WHERE TYPE='U'
数据库、表名
SELECT * FROM INFORMATION_SCHEMA.TABLES