DB Test Driven

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.

Arguments

• v_Object_Name – Synonym Name, SYSNAME

Examples

SQL Server

      EXECUTE DBTD_DROP_SYNONYM_IF_EXISTS 'altTableName';

      EXECUTE DBTD_DROP_SYNONYM_IF_EXISTS '​MyServer.MyDatabase.MySchema.altTableName';

See Also

• DBTestDriven Framework Tools
• DBTD_DROP_TABLE_IF_EXISTS
• DBTD_DROP_VIEW_IF_EXISTS
• DBTD_DROP_SEQUENCE_IF_EXISTS
• DBTD_DROP_INDEX_IF_EXISTS
• DBTD_DROP_TRIGGER_IF_EXISTS
• DBTD_DROP_PROC_IF_EXISTS
• DBTD_DROP_FULLTEXT_CATALOG_IF_EXISTS
• DBTD_DROP_FULLTEXT_INDEX_IF_EXISTS