Search code examples
pythonmonetdbsquirrel-sql

MonetDB delete table fully

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

Solution

  • According to MonetDB documentation, it should be 

    drop table <table_name>

    Read more about the Drop Statement.