#10464: Missing synonym and trigger objects in dependencies tab in table properties.

nileshhmali reported 2013-10-16T08:58:42Z · last modified 2014-02-23T12:16:32Z

Dev	ivangron
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	App - Visual Editing
Version	Future - .1

Database version :Ms sql server 2012

ADS version :ADS-windows-x64-14.0-rc-44

Connect Ms sql server 2012.

Create simple table

CREATE TABLE "db_accessadmin"."Test_depend_prop" (

"col1" bigint NULL,

"col2" varchar(25) NULL,

"col3" varchar(25) NULL

)

Create simple trigger

CREATE TRIGGER "db_accessadmin"."Test_trigger_dep"

ON "db_accessadmin"."test_depend_prop"

FOR INSERT

Begin

INSERT INTO "db_accessadmin"."table12"("c1", "c2", "c3", "c4", "c5")

VALUES(1, 'sdf', 12, '2013-10-16 12:56:2', '2013-10-16')

End

Create simple synonym

CREATE SYNONYM "db_accessadmin"."Synonyms_depend_prop"

FOR "db_accessadmin"."Test_depend_prop"

Go to table node->Right click on table 'Test_depend_prop' and select table properties->Switch to Dependencies tab.

Now you will observe that Missing synonyms and trigger objects in Dependencies.

All Comments (1) Change History

tariqrahiman 2013-10-18T01:28:08Z

@Ivan: is it possible to include triggers and synonyms as SQL Management Studio ?