Error - Only an ET or null statement is legal after a DDL Statement.

Teradata Studio
Enthusiast

Error - Only an ET or null statement is legal after a DDL Statement.

Hi, Everyone I want to drop some tables and creat new tables by TD studio. But I can execute the sql just one by one. If not, there is an error as the subject. [Only an ET or null statements is legal after a DDL statement] Where is the settings that I can execute them together. Thank you for your help.
Tags (2)
2 REPLIES 2
Teradata Employee

Re: Error - Only an ET or null statement is legal after a DDL Statement.

Try with the Session mode set to ANSI in the connection pofile properties

Teradata Employee

Re: Error - Only an ET or null statement is legal after a DDL Statement.

You must "Execute as individual statements" (which includes execution of multiple statements in series) not "Execute all as one statement" (multiple statements in parallel, but only DML).

And be sure Autocommit is checked.