The meta data is from an SQL 2012 Server.
I have posted alot more, find the whole list here.
Goto Definition or MetaData
Definition:
sys.sp_foreign_keys_rowset_rmt(nvarchar @server_name, nvarchar @pk_table_name
, nvarchar @pk_table_schema
, nvarchar @pk_table_catalog
, nvarchar @foreignkey_tab_name
, nvarchar @foreignkey_tab_schema
, nvarchar @foreignkey_tab_catalog)
MetaData:
create procedure sys.sp_foreign_keys_rowset_rmt ( @server_name sysname, @pk_table_name sysname = null, @pk_table_schema sysname = null, @pk_table_catalog sysname = null, @foreignkey_tab_name sysname = null, @foreignkey_tab_schema sysname = null, @foreignkey_tab_catalog sysname = null ) as select PK_TABLE_CATALOG, PK_TABLE_SCHEMA, PK_TABLE_NAME, PK_COLUMN_NAME, PK_COLUMN_GUID, PK_COLUMN_PROPID, FK_TABLE_CATALOG, FK_TABLE_SCHEMA, FK_TABLE_NAME, FK_COLUMN_NAME, FK_COLUMN_GUID, FK_COLUMN_PROPID, ORDINAL, UPDATE_RULE, DELETE_RULE, PK_NAME = null, -- ISSUE these 3 columns must be exported by the server FK_NAME = null, -- in \yukon\sql\ntdbms\msql\ddl\sysoledb.cpp : DEFERRABILITY = null -- const SCHEMA_COLUMNS xCol_FOREIGN_KEYS = { from sys.fn_remote_foreign_keys (@server_name, @pk_table_catalog, @pk_table_schema, @pk_table_name, @foreignkey_tab_catalog, @foreignkey_tab_schema, @foreignkey_tab_name) order by 7,8,9,1,2,3,13
No comments:
Post a Comment