delete in sql

Apr 21 2014 1:25 AM

Hi,

I have a database 'Database1'.

Inside that i have multi-company structure as Company1, Company2 & so on.

I want to delete all the tables within Comapany1 including system tables, data tables with their data at one instance. Currently, i have to go to each table and press delete manually.

Can anyone please help with SQL query to carry out this task.

eg: Each type has 3 kinds of tables created. I want to delete entire things of Company1

dbo.Company1.MySettings.data

dbo.Company1.MySettings.sidedata

dbo.Company1.MySettings.audit

dbo.Company1.MyContacts.data

dbo.Company1.MyContacts.sidedata

dbo.Company1.MyContacts.audit

Answers (4)

Regarding SQLException

Join Multiple Columns and Get value in Same Column.