ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

How to remove a UNIQUE key

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to remove a UNIQUE key

    I have a sql table that was created with a primary key. I deleted the primary key but the file still has a unique key there.
    I tried to use the alter table, but it shows type *N not found. I also tried RMVPFCST, failed too.
    Any ideas on how to remove the unique key? Thank you

  • #2
    In ACS, launch Schemas (under Database). In Schemas, click your DB->Schemas->your schema->Tables. Double-click on the table in question and go to the Key Constraints tab. The unique constraint should be listed there and you can use the Remove button.

    If your schema isn't listed, right-click Schemas->Include to add it.

    Comment


    • lxb0007
      lxb0007 commented
      Editing a comment
      I tried and it works! Thank you jtaylor
Working...
X