Aqua Data Studio 14.0.3

Database- MS SQL Server 2012

 

In Alter table GUI,Referencing table drop down does not list the table names

 

Please go through following steps:

1.I have created two tables with same name but in different schema

  Ex.

  CREATE TABLE "dbo"."a_order"  ( 

  "o_id" int NOT NULL,

  "o_no" varchar(25) NOT NULL,

  "e_id" int NOT NULL,

  CONSTRAINT "Primary_key_on_table" PRIMARY KEY CLUSTERED("o_id"))

  GO

  CREATE TABLE "guest"."a_order"  ( 

  "o_id1"   int NOT NULL,

  "o_name1" text NULL,

  CONSTRAINT "primary_key_on_table_a_order" PRIMARY KEY CLUSTERED("o_id1")

  )

  GO

  

  2.Right click on table 'dbo.a_order'->Select Alter table->Go to Constraints tab->add foreign key constraint on table->give constraint name->select    constraint type as Foreign key->select reference schema as 'guest'->select reference table,in ref table list 'guest.a_order' table name is not display.