Hello Dmitry, you wrote : > Our developer just complained that SQL Studio (or SAP DB) > drops _ALL_ > dependend views if one of them is dropped without confirmation. > Is this bug or feature? :-(
This is a feature of the database kernel, not of SQL Studio. cf. http://www.sapdb.org/htmhelp/6d/117c47d14811d2a97400a0c9449261/content.htm . Since - by its nature - the kernel can't be very interactive about such issues , it does not ask for confirmation. But you can make the drop fail if there are depending objects by giving the RESTRICT option in the drop view statement (see the above mentioned document). regards, Markus Stausberg SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
