Multiple DDL statements in the same file

Hi, I am working with teradata database. I have a .SQL in which I want to use the following

-create a backup table use base table.
-delete the data from the base table.

  • alter the base table to add primary index for two columns,
    -insert the data into base table from the backup table.
    -drop the backup table.

I tried but I am getting an error. Could someone help me with this?

Any help on this is truly appreciated.

Hi @despacito99 ,
What error was encountered?

Hi @EduardUta , It is expecting something in between each ddl.

Can you post the .sql file as well as the script that runs it? Sanitized, of course :slight_smile:

Oh and maybe post the full run output for us.

1 Like