DB Test Driven

 

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.

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

http://dbtestdriven.com/dbtd_drop_synonym_if_exists.aspx