Collection of the procedures designed to support common framework functionality  

N - Netezza
O - Oracle
S - SQL Server

Procedure Name N O S Description
DBTD_DROP_TABLE_IF_EXISTS +   + Procedure will check if table exists in the database and will attempt to drop the table
DBTD_DROP_VIEW_IF_EXISTS +   + Procedure will check if given view exists in the database and will attempt to drop the view
DBTD_DROP_PROC_IF_EXISTS +   + Procedure will check if stored procedure with the given name (and signature) exists in the database and will attempt to drop it
DBTD_DROP_SEQUENCE_IF_EXISTS +   + Procedure will check if sequence with the given name exists in the database and will attempt to drop it
DBTD_DROP_TRIGGER_IF_EXISTS +   + Procedure will check if trigger exists in the database and will attempt to drop the trigger
DBTD_DROP_INDEX_IF_EXISTS +   + Procedure will check if index exists in the database and will attempt to drop the index
DBTD_DROP_FUNC_IF_EXISTS     + Procedure will check if function with the given name exists in the database and will attempt to drop it
DBTD_DROP_SCHEMA_IF_EXISTS     + Procedure will check if schema with the given name exists in the database, and if there are any objects associated with this schema, and will attempt to drop it
DBTD_DROP_SYNONYM_IF_EXISTS     + Procedure will check if synonym with the given name exists in the database and will attempt to drop it. This procedure will only drop synonym, it will not drop the actual object that synonym is referring too
DBTD_SP_EXECUTESQL     + Procedure executes SQL Code in the context of the target database
DBTD_SPLIT_FOUR_PART_OBJECT_NAME     + Stored procedure is parsing four part object name and used by asserts to support inter database functionality. Id schema name is not provided procedure will use DBO schema by default
DBTD_PREPARE_FOUR_PART_OBJECT_NAME     + Stored procedure will take four separate part an object: server, database, schema and object name and will reconstruct them in to one string
DBTD_GET_OBJECT_ID     + Procedure returns database object identification number 
DBTD_CREATE_SCHEMA_UNIT_TEST     + Generated a Unit Test SQL Script that will verifies specified database object using related DDL Asserts
DBTD_DROP_FULLTEXT_CATALOG_IF_EXISTS     +  
DBTD_DROP_FULLTEXT_INDEX_IF_EXISTS     +  
Procedure Name N O S Description

N - Netezza
O - Oracle
S - SQL Server

 

Assert procedures should not be altered.