Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    pakistan
    Posts
    5

    Unanswered: default constraint

    how can i drop the default constaint on a column in a table - do i need to drop the column and recreate it from scratch?

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    You have to know constraint's name. Then simply drop it using

    ALTER TABLE table_name DROP CONSTRAINT cons_name;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •