sp_addarticle |
Ajout d'article |
|---|---|
| SQL Server | |
Syntaxe
|
sp_addarticle [ @publication = ] 'publication' , [ @article = ] 'article' [ , [ @source_table = ] 'source_table' ] [ , [ @destination_table = ] 'destination_table' ] [ , [ @vertical_partition = ] 'vertical_partition' ] [ , [ @type = ] 'type' ] [ , [ @filter = ] 'filter' ] [ , [ @sync_object= ] 'sync_object' ] [ , [ @ins_cmd = ] 'ins_cmd' ] [ , [ @del_cmd = ] 'del_cmd' ] [ , [ @upd_cmd = ] 'upd_cmd' ] [ , [ @creation_script = ] 'creation_script' ] [ , [ @description = ] 'description' ] [ , [ @pre_creation_cmd = ] 'pre_creation_cmd' ] [ , [ @filter_clause = ] 'filter_clause' ] [ , [ @schema_option = ] schema_option ] [ , [ @destination_owner = ] 'destination_owner' ] [ , [ @status = ] status ] [ , [ @source_owner = ] 'source_owner' ] [ , [ @sync_object_owner = ] 'sync_object_owner' ] [ , [ @filter_owner = ] 'filter_owner' ] [ , [ @source_object = ] 'source_object' ] [ , [ @artid = ] article_ID OUTPUT ] [ , [ @auto_identity_range = ] 'auto_identity_range' ] [ , [ @pub_identity_range = ] pub_identity_range ] [ , [ @identity_range = ] identity_range ] [ , [ @threshold = ] threshold ] [ , [ @force_invalidate_snapshot = ] force_invalidate_snapshot ] [ , [ @use_default_datatypes = ] use_default_datatypes [ , [ @identityrangemanagementoption = ] identityrangemanagementoption ] [ , [ @publisher = ] 'publisher' ] [ , [ @fire_triggers_on_snapshot = ] 'fire_triggers_on_snapshot' ] |
Description
Cette Stored Procedure permet de créer un article et l'ajoute à une publication. Cette STORED PROCEDURE est exécutée au niveau du Publisher sur la base de données de publication.
Dernière mise à jour : Dimanche, le 29 Août 2021