USE DATABASE2;IF OBJECT_ID_UDF('DATABASE2.DBO.TABLE1') is not null) THENDROPTABLEIFEXISTS TABLE1;ENDIF;
----** MSC-WARNING - MSCEWI4001 - Transformation for USE <database> is disabled by default. **--use database1DROPTABLEIFEXISTS TABLE1;
2. Unknown database
Code:
USE DATABASE2;IF OBJECT_ID_UDF('DATABASE1.DBO.TABLE1') is not null) THENDROPTABLEIFEXISTS TABLE1;ENDIF;
Code:
----** MSC-WARNING - MSCEWI4001 - Transformation for USE <database> is disabled by default. **--use database1IF (--** MSC-WARNING - MSCEWI1020 - CUSTOM UDF 'OBJECT_ID_UDF' INSERTED. ** OBJECT_ID_UDF('DATABASE1.DBO.TABLE1') is not null) THENDROPTABLEIFEXISTS TABLE1;ENDIF;
3. Different object names
Code:
USE DATABASE1;IF OBJECT_ID_UDF('DATABASE1.DBO.TABLE2') is not null) THENDROPTABLEIFEXISTS TABLE1;ENDIF;
Code:
----** MSC-WARNING - MSCEWI4001 - Transformation for USE <database> is disabled by default. **--use database1IF (--** MSC-WARNING - MSCEWI1020 - CUSTOM UDF 'OBJECT_ID_UDF' INSERTED. ** OBJECT_ID_UDF('DATABASE1.DBO.TABLE2') is not null) THENDROPTABLEIFEXISTS TABLE1;ENDIF;
Known issues
1. OBJECT_ID_UDF function has different behavior in certain cases
OBJECT_ID returns the object identification number but the OBJECT_ID_UDF returns a boolean value, so that they are equivalent only when OBJECT_ID is used with not null condition.