create default Restrictions

Restrictions for create default.

  • You can create a default only in the current database.

  • You cannot combine create default statements with other statements in a single batch.

  • You must drop a default using drop default before you create a new one of the same name; you must unbind a default using sp_unbindefault, before you drop it.