SQL Studio 7.4.3.6 - Show Table Definition buggy ================================================
Kernel: 7.3.0 Build 029-000-087-809 RTE: NT/INTEL 7.3.0 Build 029-000-087-809 Instance Type: OLTP Isolation Level: 0 (null) The following script fragment was used to define a table: CREATE TABLE areainenv ( env_id CHAR(32) NOT NULL, area_id CHAR(32) NOT NULL, xyz FLOAT(15) NOT NULL DEFAULT 0.0, // some other data... PRIMARY KEY (env_id,area_id), FOREIGN KEY fk_areai_env (env_id) REFERENCES environments (id) ON DELETE CASCADE, FOREIGN KEY fk_areai_area (area_id) REFERENCES areas (id) ON DELETE CASCADE ) No other things involved. Everything works well as expected. However, SQL Studio didn't show the correct table definition on the "Ref. Integrity" property page. For fk_areai_area it shows RESTRICT as the delete rule, not cascade as expected. I also tried to create this table with the gui (not with a script), but can't get it done. the needed table definitions just dont show up in the popup combos and setting cascade two times seems to be imposible via gui. a quick check with xload (catalogextract ...) shows that the original definition of the table is in effect. sql statements on the involved tables are working as intended. good luck __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
