Dropping tables from database have relations

Dropping tables from database have relations

  
Hi everyone,

i want to drop some tables from database sql server but it does not allow me to do so. i have also deleted the entry from espace id. please help.
Hi Manish,

If you want to drop table from sql server you have to use the DROP TABLE command with table name. Here is a good link from where you can get help: https://msdn.microsoft.com/en-us/library/ms173790.aspx
Hi Manish,

If you are trying to do this on your application using a SQL node then it won't work. The runtime user of the applications does not have privileges to manage the database structure. You should delete the entities in your application modules and, since this won't delete the database tables so that you can recover your data, you use the DbCleaner_API to remove those deleted tables from the database.

Cheers
Thank u everyone for the response.