deferring constraints?

• CobraFlow

  Newbie

  Points: 1

  More actions

  May 13, 2003 at 3:26 am

  #105714

  Hi,

  I'm looking for a way to defer constraint checking until a commit in SQLServer 2000. In theory I should be able to create a table with constraints that are initially deferred eg Oracle...

  Create Table TABLE1 (

  myColumn number(20) constraint nn NOT NULL INITIALLY DEFERRED....

  )

  Thanks

  Lewis

• Antares686

  SSC Guru

  Points: 125444

  More actions

  May 13, 2003 at 5:13 am

  #456951

  To the best of my knowledge there is nothing like this in SQL.