Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004

    Unanswered: disabling/enabling constraint in sybase

    I have been looking for a syntax enabling/disabling unique constraint in sybase instead of adding/dropping.

    Does anybody know the syntax?


  2. #2
    Join Date
    Mar 2009
    Sydney, Australia
    There is no disable/enable "syntax" for Unique constraints; AFAIK, that's across all ANSI SQL RDBMSs. Under the covers, Unique and PK constraints are simply indices. Add/drop Unique/Primary Key constraints or add/drop [Unique] [Clustered] Index do exactly the same thing.

    You can enable/disable a trigger.
    Derek Asirvadem (Formerly DerekA)
    Information Architect / Senior Sybase DBA
    Copyright 2009 Software Gems Pty Ltd

    I answer questions from the Original Poster only. If you have a genuine question, as the moderators have requested, start a new thread.

Posting Permissions

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