分布式查询存储过程 (Transact-SQL)Distributed Queries Stored Procedures (Transact-SQL)

适用于: 是SQL Server 否Azure SQL 数据库 否Azure Synapse Analytics (SQL DW) 否并行数据仓库 APPLIES TO: YesSQL Server NoAzure SQL Database NoAzure Synapse Analytics (SQL DW) NoParallel Data Warehouse

SQL ServerSQL Server 支持以下用于实现和管理分布式查询的系统存储过程。supports the following system stored procedures that are used to implement and manage Distributed Queries.

sp_addlinkedserversp_addlinkedserver sp_indexessp_indexes
sp_addlinkedsrvloginsp_addlinkedsrvlogin sp_linkedserverssp_linkedservers
sp_catalogssp_catalogs sp_primarykeyssp_primarykeys
sp_column_privileges_exsp_column_privileges_ex sp_serveroptionsp_serveroption
sp_columns_exsp_columns_ex sp_table_privileges_exsp_table_privileges_ex
sp_droplinkedsrvloginsp_droplinkedsrvlogin sp_tables_exsp_tables_ex
sp_dropserver (Transact-SQL)sp_dropserver (Transact-SQL) sp_testlinkedserver (Transact-sql)sp_testlinkedserver (Transact-SQL)
sp_foreignkeyssp_foreignkeys

另请参阅See Also

系统存储过程 (Transact-SQL)System Stored Procedures (Transact-SQL)