DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: dropping Unique constraints

  1. 02-08-2001, 06:48 PM #1
    chrissy
    chrissy is offline Junior Member
    Join Date
    Oct 2000
    Posts
    56
    hello, i'm having problems disabling unique constraints and check constraints...

    the syntax is
    alter table table_name disable unique (column_name)
    ...
    but i don't know how to figure out what columns are considered unique on what tables


    thanks
    Reply With Quote Reply With Quote
  2. 02-08-2001, 06:53 PM #2
    sysdba
    sysdba is offline Senior Member
    Join Date
    Jun 2000
    Posts
    295
    check out
    user_cons_columns.
    Reply With Quote Reply With Quote
  3. 02-08-2001, 06:54 PM #3
    dragon99
    dragon99 is offline Member
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    Do a querry on USER_CONSTRAINTS, you will get the info you need.
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules

Click Here to Expand Forum to Full Width