This class of asserts will perform DDL verification such as object existence in the database, column types, or specifies common object characteristics

N - Netezza
O - Oracle
S - SQL Server

Assert Procedure N O S Description
DDL Assertions 
DBTD_ASSERT_TABLE_EXISTS + + + Checks that table exists in the database. Report failure if table not found.
DBTD_ASSERT_TABLE_NOT_EXISTS + + + Checks that table does not exist in the database. Fails when given table is found.
DBTD_ASSERT_VIEW_EXISTS + + + Checks that view exist in the database. Fails when given view is not found.
DBTD_ASSERT_VIEW_NOT_EXISTS + + + Checks that view do not exist in the database. Fails when given view is found.
DBTD_ASSERT_TABLE_OR_VIEW_EXISTS + + + Asserts that table or view with a given name exist in the database. Procedure will fail when object is missing.
DBTD_ASSERT_PROC_NOT_EXISTS +

+

+ Validates that stored procedure does not exist in the database. Assert will fail when object is found in the database.
DBTD_ASSERT_PROC_EXISTS + + + Validates that given stored procedure exist in a database. Assert will fail when object has not been found in the database.
DBTD_ASSERT_FUNC_EXISTS     + Validates that given function exist in a database. Assert will fail when object has not been found in the database.
DBTD_ASSERT_FUNC_NOT_EXISTS     + Validates that function does not exist in the database. Assert will fail when object is found in the database.
DBTD_ASSERT_PARAMETER_EXISTS     + Checks that parameter exist for an object that accepts parameters. Assert will fail when parameter with a given name could not be found
DBTD_ASSERT_SYNONYM_EXISTS     + Validates that synonym exist in a database. Assert will fail when object has not been found in the database.
DBTD_ASSERT_SYNONYM_NOT_EXISTS     + Validates that synonym does not exist in the database. Assert will fail when object is found in the database.
DBTD_ASSERT_OBJECT_EXISTS     + Verifies that database object exists. Fail when object with a given name has not been found in the database.
DBTD_ASSERT_OBJECT_NOT_EXISTS     + Verifies that database object does not exists. Fail when object with a given name has been found in a database.
DBTD_ASSERT_DEFAULT_CONSTRAINT     + Verifies that table has default constraint with a given name and that this constrain have expected value. Fail when default constraint is not found or when default constraint value does not match expected value.
DBTD_ASSERT_COLUMN_EXISTS + + + Validates that provided table (or a view) have a column with the specified name. Assert will fail when column does not exist in the provided object.
DBTD_ASSERT_COLUMN_NOT_EXISTS + + + Validates that provided table (or a view) do not have a column with the specified name. Assert will fail when column found for the provided object.
DBTD_ASSERT_COLUMN_IS_NULLABLE + + + Validates that column is nullable in the existing table, or that it allows NULL values to be stored in the column. Assert will fail if column is not nullable.
DBTD_ASSERT_COLUMN_IS_NOT_NULLABLE + + + Validates that specified column is NOT nullable for the existing table, in other words it checks that NULL values cannot be stored in the column. Assert will fail if column is nullable.
DBTD_ASSERT_COLUMN_TYPE + + + Assert validates data type of a specified column. Assert will fail if data type do not match.
DBTD_ASSERT_COLUMN_TYPE_AND_PRECISION + + + Assert validates columns data type, precision and scale. Assert will fail if data type or precision/scale do not match.
DBTD_ASSERT_DB_EXISTS +   + Assert verifies that database exists on the server. Fail when database with a given name has not been found on the server.
DBTD_ASSERT_DB_NOT_EXISTS +   + Assert verifies that database does not exists on the server. Fail when database with a given name has been found on the server.
DBTD_ASSERT_TRIGGER_EXISTS ? + + Assert verifies that trigger exists. Fail when trigger with a given name has not been found in the database.
DBTD_ASSERT_TRIGGER_NOT_EXISTS ? + + Assert verifies that trigger does not exists. Fail when trigger with a given name has been found in the database.
DBTD_ASSERT_INDEX_EXISTS ? + + Assert verifies that index exists with given name and for a specified table. Fail when index has not been found for a specified table.
DBTD_ASSERT_INDEX_NOT_EXISTS ? + + Assert verifies that index with given name does not exists. Fail when index has not been found for a specified table.
DBTD_ASSERT_INDEX_NOT_CLUSTERED     + Assert verifies that specified index is NOT a clustered index. Fail when index has not been found or when index is a clustered index.
DBTD_ASSERT_INDEX_CLUSTERED     + Assert verifies that index specified as clustered index for a given table. Fail when index has not been found or when it is not a clustered index.
DBTD_ASSERT_INDEX_NOT_UNIQUE + + + Assert verifies that specified index is not a unique index. Fail when index has not been found for a specified table or when it does enforce unique values.
DBTD_ASSERT_INDEX_UNIQUE + + + Assert verifies that specified index is unique index. Fail when index has not been found for a specified table or when it does not enforce unique values.
DBTD_ASSERT_INDEX_FILTERED     + Assert verifies that FILTERED index exists with given name, expected filter criteria and for a specified table. Fail when index has not been found for a specified table, fails when filtering criteria do not match, or when index is is any other type but filtered
DBTD_ASSERT_INDEX_XML     + Assert verifies that index is the XML index. Fail when index has not been found for a specified table and when index is not an XML index
DBTD_ASSERT_INDEX_SPATIAL     + Assert verifies that index is the SPATIAL index. Fail when index has not been found for a specified table or when index is not a spatial index
DBTD_ASSERT_INDEX_FULLTEXT     + Assert verifies that index is a FULLTEXT index. Fail when index has not been found for a specified table or when table does not have full text index defined
DBTD_ASSERT_INDEX_COLUMNSTORE     + Assert verifies that index is the COLUMNSTORE index. Fail when index has not been found for a specified table, fails when index with a given name is not a column store index
Assert Procedure N O S Description

N - Netezza
O - Oracle
S - SQL Server

 

Assert procedures should not be altered.