Sinc I'm new to this platform, I need to remodel the database frequently 

Can someone tell me how to drop table in outsystems?

I tried
select {Contacts}.* from {Contacts} drop

This is accepted but comes with an exceptione error during runtime

kind regards 
Dop hegger
OUR Solutions
Hi Dop.

Try the following sintax:

DROP TABLE {Contacts}

Tanks for your help Daniel.

unfortunately it does not work. The word Table at causes a yellow warning line:

unexpected 'table' in sql statement

kind regards
dop hegger
Hi Dop,

Due to security reasons the runtime user does not have permissions to alter/drop tables.

You will have to connect to your sql server manually to perform those types of operations.

João Rosado