Procedure will check if given view exists in the database and will attempt to drop the view.
Arguments
-
v_Object_Name – View Name, Variable Character (128) in Netezza, SYSNAME in SQL Server..
Note:
Supported in Netezza and SQL Server versions at this time.
As workaround In the Oracle version of the framework please use ‘WHENEVER SQLERROR CONTINUE’ command where needed;
Examples
SQL Server
EXEC DBTD_DROP_VIEW_IF_EXISTS 'MY_VIEW';
EXEC DBTD_DROP_VIEW_IF_EXISTS 'MyServer.MyDatabase.MySchema.MY_VIEW';
Netezza
CALL DBTD_DROP_VIEW_IF_EXISTS('VW_TEST');
See Also