Check Constrain to existing table

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734449

  More actions

  April 23, 2016 at 1:12 pm

  #400065

  A short piece that has a scenario of an existing table with some bad data. We want to prevent more, so we add a check constraint. However we don't want to check existing data.

  Then we can clean up bad data over time.

  A short story that shows how this might work.

• Hugo Kornelis

  SSC Guru

  Points: 64780

  More actions

  April 23, 2016 at 2:13 pm

  #1874104

  I can take this one. Nice synergy with my article on trusted vs untrusted constraints.

  I am quite busy so if you're in a hurry you'll need to find someone else.

  (And you might want to send me a reminder after some time)

  ---

  Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
  Visit my SQL Server blog: https://sqlserverfast.com/blog/
  SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/