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.