Delete multiple tables SQL

Question

I have tried to delete multiple data/rows tables, but does not allow me as the error starts at -> a, b, c, d, e <- that says "invalid column" and not find what is my mistake ... here my code:

DELETE a.*,b.*,c.*,d.*,e.* FROM [CatMngSys].[Providers] a
INNER JOIN [Security].[UsersProviders] b
ON a.Id = b.ProviderId
INNER JOIN [Security].[Users] c
ON b.UserId = c.Id
INNER JOIN [CatMngSys].[ProviderSubscriptions] d
ON d.ProviderId = a.Id
INNER JOIN [CatMngSys].[Subscriptions] e
ON e.Id = d.SubscriptionId
WHERE a.id = @Id

and i have tried for many options:

DELETE FROM 
DELETE * FROM
DELETE a.*,b.*,c.*,d.*,e.*

Which RDBMS is this for? Please add a tag to specify whether you're using mysql, postgresql, sql-server, oracle or db2 - or something else entirely. — marc_s
– marc_s, Commented Feb 12, 2016 at 5:55

PodTech.io · Accepted Answer · 2016-02-11 23:56:23Z

1

 DROP TABLE table1,table2,table3 ...

answered Feb 11, 2016 at 23:56

PodTech.io

5,31245 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

AnubisVolga Over a year ago

hmmm i don't want to delete the tables... only specific rows of every tables

PodTech.io Over a year ago

joining a-b-c-d, tryed this? WHERE a.id=b.providerId AND b.userid=c.id ..... instead of a.id=@id.

Adrian Lynch · Accepted Answer · 2016-02-12 00:36:03Z

0

Remove the columns (*) from the DELETE clause:

DELETE a, b, c, d, e
FROM [CatMngSys].[Providers] a
INNER JOIN [Security].[UsersProviders] b ON a.Id = b.ProviderId
INNER JOIN [Security].[Users] c ON b.UserId = c.Id
INNER JOIN [CatMngSys].[ProviderSubscriptions] d ON d.ProviderId = a.Id
INNER JOIN [CatMngSys].[Subscriptions] e ON e.Id = d.SubscriptionId
WHERE a.id = @Id

This'll delete matching rows in each of tables Providers, UsersProviders, Users, ProviderSubscriptions and Subscriptions.

answered Feb 12, 2016 at 0:36

Adrian Lynch

8,5442 gold badges36 silver badges41 bronze badges

1 Comment

Adrian Lynch Over a year ago

Is it SQL Server? What error or incorrect response are you seeing. Can you create two test tables with data and test the same type of query?

marc_s · Accepted Answer · 2016-02-12 05:54:40Z

0

DELETE t1, t2 
FROM t1 
INNER JOIN t2 
INNER JOIN t3
WHERE t1.id = t2.id AND t2.id = t3.id;

edited Feb 12, 2016 at 5:54

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Feb 12, 2016 at 0:00

Alvaro

1,4483 gold badges24 silver badges43 bronze badges

1 Comment

AnubisVolga Over a year ago

... sorry i need to delete multiple tables, not one table

Collectives™ on Stack Overflow

Delete multiple tables SQL

3 Answers 3

2 Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related