Announcement

Collapse
No announcement yet.

Navicat keeps trying to recreate foreign keys on a table edit

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

  • Navicat keeps trying to recreate foreign keys on a table edit

    When I use "Design Table" on a table with foreign keys, the opened window's SQL Preview tab already holds this even before I make any changes:

    Code:
    ALTER TABLE "CRONOS"."PLAYLIST_TRACKS" DROP CONSTRAINT "FK_PLAYLIST_ID";
    
    ALTER TABLE "CRONOS"."PLAYLIST_TRACKS" ADD CONSTRAINT "FK_PLAYLIST_ID" FOREIGN KEY ("PLAYLIST_ID", "") REFERENCES "CRONOS"."PLAYLIST" ("PLAYLIST_ID") ON DELETE CASCADE;
                                                                          The problem seems to be here ^^

  • #2
    Could you please provide the following information for investigation?

    1. Your Navicat version, e.g. Navicat Premium (Window) 11.1.11

    2. Your Server version, e.g. Oracle 10g

    Comment


    • #3
      1. Navicat Premium 11.1.11 Windows 64-bit

      2. Client: 11.2.0.4.0, Server: 11.2.0.1.0

      Comment


      • #4
        Hi odbayar,

        Thanks for the information provided. We are able to identify the problem and our development team is trying to fix it. We sincerely hope the next version will be published together with the bug-fixing. We will contact you if any news.

        Comment

        Working...
        X