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