SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2008
Product Documentation
SQL Server 2008 Books Online
Replication
Technical Reference
Replication Tables (Transact-SQL)
conflict_<schema>_<table> (Transact-SQL)
IHarticles (Transact-SQL)
IHcolumns (Transact-SQL)
IHconstrainttypes (Transact-SQL)
IHindextypes (Transact-SQL)
IHpublications (Transact-SQL)
IHpublishercolumnconstraints (Transact-SQL)
IHpublishercolumnindexes (Transact-SQL)
IHpublishercolumns (Transact-SQL)
IHpublisherconstraints (Transact-SQL)
IHpublisherindexes (Transact-SQL)
IHpublishers (Transact-SQL)
IHpublishertables (Transact-SQL)
IHsubscriptions (Transact-SQL)
MSagent_parameters (Transact-SQL)
MSagent_profiles (Transact-SQL)
MSagentparameterlist (Transact-SQL)
MSarticles (Transact-SQL)
MScached_peer_lsns (Transact-SQL)
MSdbms (Transact-SQL)
MSdbms_datatype (Transact-SQL)
MSdbms_datatype_mapping (Transact-SQL)
MSdbms_map (Transact-SQL)
MSdistpublishers (Transact-SQL)
MSdistribution_agents (Transact-SQL)
MSdistribution_history (Transact-SQL)
MSdistributiondbs (Transact-SQL)
MSdistributor (Transact-SQL)
MSdynamicsnapshotjobs (Transact-SQL)
MSdynamicsnapshotviews (Transact-SQL)
MSlogreader_agents (Transact-SQL)
MSlogreader_history (Transact-SQL)
MSmerge_agents (Transact-SQL)
MSmerge_articlehistory (Transact-SQL)
MSmerge_altsyncpartners (Transact-SQL)
MSmerge_conflict_<publication>_<article> (Transact-SQL)
MSmerge_conflicts_info (Transact-SQL)
MSmerge_contents (Transact-SQL)
MSmerge_current_partition_mappings
MSmerge_dynamic_snapshots (Transact-SQL)
MSmerge_errorlineage (Transact-SQL)
MSmerge_generation_partition_mappings (Transact-SQL)
MSmerge_genhistory (Transact-SQL)
MSmerge_history (Transact-SQL)
MSmerge_identity_range (Transact-SQL)
MSmerge_identity_range_allocations (Transact-SQL)
MSmerge_metadataaction_request (Transact-SQL)
MSmerge_partition_groups (Transact-SQL)
MSmerge_past_partition_mappings (Transact-SQL)
MSmerge_replinfo (Transact-SQL)
MSmerge_sessions (Transact-SQL)
MSmerge_settingshistory (Transact-SQL)
MSmerge_subscriptions (Transact-SQL)
MSmerge_tombstone (Transact-SQL)
MSpeer_conflictdetectionconfigrequest (Transact-SQL)
MSpeer_conflictdetectionconfigresponse (Transact-SQL)
MSpeer_lsns (Transact-SQL)
MSpeer_originatorid_history (Transact-SQL)
MSpeer_request (Transact-SQL)
MSpeer_response (Transact-SQL)
MSpeer_topologyrequest (Transact-SQL)
MSpeer_topologyresponse (Transact-SQL)
MSpub_identity_range (Transact-SQL)
MSpublication_access (Transact-SQL)
MSpublications (Transact-SQL)
MSpublicationthresholds (Transact-SQL)
MSpublisher_databases (Transact-SQL)
MSqreader_agents (Transact-SQL)
MSqreader_history (Transact-SQL)
MSrepl_backup_lsns (Transact-SQL)
MSrepl_commands (Transact-SQL)
MSrepl_errors (Transact-SQL)
MSrepl_identity_range (Transact-SQL)
MSrepl_originators (Transact-SQL)
MSrepl_queuedtraninfo (Transact-SQL)
MSrepl_transactions (Transact-SQL)
MSrepl_version (Transact-SQL)
MSreplication_monitordata (Transact-SQL)
MSreplication_objects (Transact-SQL)
MSreplication_options (Transact-SQL)
MSreplication_queue (Transact-SQL)
MSreplication_subscriptions (Transact-SQL)
MSreplmonthresholdmetrics (Transact-SQL)
MSsnapshot_agents (Transact-SQL)
MSsnapshot_history (Transact-SQL)
MSsnapshotdeliveryprogress (Transact-SQL)
MSsub_identity_range (Transact-SQL)
MSsubscriber_info (Transact-SQL)
MSsubscriber_schedule (Transact-SQL)
MSsubscription_agents (Transact-SQL)
MSsubscription_articles (Transact-SQL)
MSsubscription_properties (Transact-SQL)
MSsubscriptions (Transact-SQL)
MSsync_states (Transact-SQL)
MStracer_history (Transact-SQL)
MStracer_tokens (Transact-SQL)
sysarticlecolumns (Transact-SQL)
sysarticles (Transact-SQL)
sysarticleupdates (Transact-SQL)
sysmergearticlecolumns (Transact-SQL)
sysmergearticles (Transact-SQL)
sysmergepartitioninfo (Transact-SQL)
sysmergepublications (Transact-SQL)
sysmergeschemaarticles (Transact-SQL)
sysmergeschemachange (Transact-SQL)
sysmergesubscriptions (Transact-SQL)
sysmergesubsetfilters (Transact-SQL)
syspublications (Transact-SQL)
sysreplicationalerts (Transact-SQL)
syssubscriptions (Transact-SQL)
sysschemaarticles (Transact-SQL)
Expand Minimize
This topic has not yet been rated - Rate this topic

IHconstrainttypes (Transact-SQL)

SQL Server 2008

The IHconstrainttypes system table contains one row for each type of non-SQL Server constraint supported for non-SQL Server Publishers. This table is stored in the distribution database.

Column name

Data type

Description

type

nvarchar(255)

The name of a supported non-SQL Server constraint type.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.