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