Liquibase ：预期介于"TABLE"关键字和"IF"关键字之间的内容

Question

我正试图通过liquidbase运行下面的sql，我得到一个错误，预期在"表"关键词"if";关键字。这是为teradata数据库

CREATE MULTISET TABLE IF NOT EXISTS SCHEMA_NAME.TABLE_NAME, NO, FALLBACK,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT,
DEFAULT MERGEBLOCKRATIO AS ( I TRIED WITHOUT "AS")
(
COL1 INTEGER,
COL1 INTEGER....ETC)
PRIMARY INDEX( COL1,COL2);

Answer 1

REPLACE PROCEDURE <database_name>.drop_if_exists( in_object varchar(50)) begin IF EXISTS(
SELECT  1 
FROM    dbc.tables 
WHERE   tablename = in_object 
and databasename='<database_name>') THEN 
CALL DBC.SysExecSQL('DROP TABLE ' || in_object); 
END IF; END;

后面跟着常规的create table语句