Home Microsoft SQL Server DigiMailing Contact
    Keyword



  On Constraints Microsoft SQL Server supplies you with the following objects:

Procedure
  • sys.sp_check_constraints_rowset
  • sys.sp_check_constraints_rowset2
  • sys.sp_helpconstraint
  • sys.sp_IHVerifyConstraint
  • sys.sp_MScreatelightweightprocstriggersconstraints
  • sys.sp_MScreate_zero_identity_constraint
  • sys.sp_MSdroparticleconstraints
  • sys.sp_MSdropconstraints
  • sys.sp_MSfixup_constraints_name
  • sys.sp_MSis_joinfilter_based_on_PK_UQ_constraints
  • sys.sp_MSmergefixup_constraints_name
  • sys.sp_MSrefresh_idrange_check_constraint
  • sys.sp_table_constraints_rowset
  • sys.sp_table_constraints_rowset2


  • View
  • sys.check_constraints
  • INFORMATION_SCHEMA.CHECK_CONSTRAINTS
  • INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE
  • INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE
  • sys.default_constraints
  • INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS
  • sys.key_constraints
  • INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS
  • sys.sysconstraints
  • INFORMATION_SCHEMA.TABLE_CONSTRAINTS