MonetDB delete table fully

Question

I had created some tables in sys. how to delete them fully? can i do that : 1.drop table [your_tablename] 2.delete table [your_tablename] but my teacher told me that is wrong,how should I write a SQL statement?

and my MonetDB's version is [MonetDB Database Server Toolkit v1.1 (Jul2015-SP2)]

i used squirrel to connect.like this:

enter image description here

if i drop a lots of tables(maybe there tablename is the same) ,how to know the table where i drop is in sys? can i do like this :set schema sys;drop table <table_name> — xiang Gao

Forge Forge · Accepted Answer · 2016-03-03T06:14:31

According to MonetDB documentation, it should be

drop table <table_name>

MonetDB delete table fully

1 Answers