search

FirebirdSQL / firebird

Firebird server, client and tools
https://www.firebirdsql.org/
1.23k stars 213 forks source link

drop <object> <object_name> with dependencies [CORE1947] #2385

Open firebird-automations opened 16 years ago

firebird-automations commented 16 years ago

Submitted by: Valdir Stiebe Junior (ogecrom)

Attachments: XX - CREATE DROP triggers&views&procedures.sql XX - DROP triggers&views&procedures.sql

Votes: 2

Add the "with dependencies" to the drop <object> command.

firebird-automations commented 16 years ago

Commented by: Valdir Stiebe Junior (ogecrom)

This script files are the way we use to update our database today. We drop all triggers, views and procedures in a recursive way for then, update the DDL for the tables, and then recreate all the new triggers, views and procedures.

The "with dependencies" option for the drop command would help developers who work with complex triggers, views and procedures dependencies.

firebird-automations commented 16 years ago
Modified by: Valdir Stiebe Junior (ogecrom) Attachment: XX \- CREATE DROP triggers&views&procedures\.sql \[ 10940 \] Attachment: XX \- DROP triggers&views&procedures\.sql \[ 10941 \]
firebird-automations commented 16 years ago

Commented by: Bjoern Reimer (bnreimer)

May be the keyword should be CASCED like in PostgreSQL

e.g. DROP TABLE products CASCADE;

firebird-automations commented 16 years ago

Commented by: Valdir Stiebe Junior (ogecrom)

Sorry, the attached scripts have problems with circular dependencies.