Two questions.

 

 

1. Can I execute a dynamic DDL statement using PSM?

 

2. I am trying to create a script where I would like to DROP A TABLE before re-creating it. If I include the DROP TABLE in the script, MonetDB throws an error and STOPs execution if the table is not found. This is rather painful as I would like MonetDB to continue with the next SQL command. For. e.g

 

DROP TABLE table1 ;

CREATE TABLE table1 ....

 

 

If I include the above 2 commands in one script, then the above scripts stops execution if "table1" doesn't exists.

 

Thanks,

 

-Venks