How to delete Jalo class or how to delete existing table entry from DB

[former_member1004967]

I have created One table in items.xml. Now I need to delete that particular table. so I have commented those lines in xml files and run ant clean all. But Jalo class created for that particular table is not removing even if we give ant clean cmd also. we need to delete manually in particular folder path. Please suggest a way to delete the existing table from DB.

[arvind-kumar_avinash]

Hi Marimuthu P - please check the syntax at https://www.w3schools.com/sql/sql_drop_table.asp

[arvind-kumar_avinash · Accepted solution]

The ant clean command or system update does not delete the the database table. The database table can be deleted using system intialization but this is not an option in most cases. Therefore, the only option you are left with is to delete the database table using SQL.

[arvind-kumar_avinash · Accepted solution]

Hi - did it help?

[former_member1004967 · Accepted solution]

Hi Arvind,

Thanks for your suggestion. Actually, we have tried to remove one component from DB as I mentioned earlier. For now, we remove that component from ComponentTypGroup table, so it won't show in the front end for Content Editors. 🙂

[arvind-kumar_avinash · Accepted solution]

Great! You are most welcome.

[Former Member · Accepted solution]

can u help me out how it's possible to delete the table using SQL please

[arvind-kumar_avinash · Accepted solution]

Hi Marimuthu P - please check the syntax at https://www.w3schools.com/sql/sql_drop_table.asp