Skip to Content (Press Enter)
2019-11-11 17-10-24
Manish Jawla
 
MVP
339Views
3Comments
Dropping tables from database have relations
Question
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.
0
0
27 Apr 2015
Copy Link
2015-04-11 11-32-52
Tama
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
1
0
28 Apr 2015
Copy Link
2020-03-05 15-52-45
André Vieira
Staff
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
1
0
29 Apr 2015
Copy Link
2019-11-11 17-10-24
Manish Jawla
 
MVP
Thank u everyone for the response.
0
0
30 Apr 2015
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.