I am attempting to write a macro to delete and drop specific tables from a database. Any suggestions on fixing this or a better method?
CREATE MACRO tbl_nme AS
WHERE DataBaseName = 'MyDatabase_A_001' AND TABLENAME NOT IN('table_1','table_2','table_3') ;) ;
EXECUTE DELETE ("MyDatabase_A_001".":tbl_nme") ;
Which returns this error:
EXECUTE Failed.  Syntax error, expected something like a name or a Unicode delimited identifier or an 'UDFCALLNAME' keyword between the 'EXECUTE' keyword and the 'DELETE' keyword.