0

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

Nakilon
  • 34,866
  • 14
  • 107
  • 142
xiang Gao
  • 39
  • 1
  • 6

1 Answers1

2

According to MonetDB documentation, it should be 

drop table <table_name>

Read more about the Drop Statement.

Forge
  • 6,538
  • 6
  • 44
  • 64
  • sorry bro,is my fault.my english is so bad that i can't explain my problem clearly.the tables which i created was in Multiple servers（192.168.1.100..200）and there are three port per ip(means every server has three db).something wrong when i only used sqlcmd like:drop table .finally in my classmate's help,i solve it. – xiang Gao Mar 03 '16 at 09:29
  • sqlcmd:set schema sys;drop table ;delete from _tables where schema_id in(select id from schemas where name = 'sys') and name = – xiang Gao Mar 03 '16 at 09:31
  • tks,for your answer. – xiang Gao Mar 03 '16 at 09:32