SQLQuery to delete Account

[azatain]

I need a SQLQuery to delete accounts fully
Delete existing characters, delete clans, etc ...

 

[Dave]

TRUNCATE TABLE Account
TRUNCATE TABLE AccountItem
TRUNCATE TABLE Character
TRUNCATE TABLE CharacterItem
TRUNCATE TABLE Clan
TRUNCATE TABLE ClanMember
TRUNCATE TABLE Friend
TRUNCATE TABLE Login

Execute in Microsoft SQL Server.
An error will pop-up when you try to execute it but just press continue, it will work.

If anyone noticed I forgot a table, post it here.

 

[Cock]

TRUNCATE TABLE Account
TRUNCATE TABLE AccountItem
TRUNCATE TABLE Character
TRUNCATE TABLE CharacterItem
TRUNCATE TABLE Clan
TRUNCATE TABLE ClanMember
TRUNCATE TABLE Friend
TRUNCATE TABLE Login

Execute in Microsoft SQL Server.
An error will pop-up when you try to execute it but just press continue, it will work.

If anyone noticed I forgot a table, post it here.

Well, that will delete all of the accounts, he said only 1 acc D:

 

[Dave]

According to his post he said he wanted to "delete existing accounts, characters, clans fully"

 

[Cock]

But his title says SQLQuery to delete account, lol confusing at least you gave it some effort ;3.

 

[azatain]

i need to delete 1 account :s

 

[Military]

i need to delete 1 account :s

Do it manually?

 

[azatain]

Do it manually?

Yes....

 

[iceman4154]

Dude.
DELETE FROM Account WHERE User ID='[put user id here]'
DELETE FROM Login WHERE User ID='[put user id here]'

Example:
DELETE FROM Account WHERE User ID='iceman4154'

 

[azatain]

Dude.
DELETE FROM Account WHERE User ID='[put user id here]'
DELETE FROM Login WHERE User ID='[put user id here]'

Example:
DELETE FROM Account WHERE User ID='iceman4154'

Yes, it deletes the accounts, but I need to delete completely and all its dependencies, Characters, Clans, Friends of the characters, etc...

 

[Cock]

DELETE FROM Account WHERE AID='[AID]'
DELETE FROM Login WHERE AID='[AID]'
DELETE FROM Character WHERE AID='[AID]'
DELETE FROM Clan WHERE NAME='[Name]'

 

[Demantor]

DELETE FROM Account WHERE AID='[AID]'
DELETE FROM Login WHERE AID='[AID]'
DELETE FROM Character WHERE AID='[AID]'
DELETE FROM Clan WHERE NAME='[Name]'

The Order should be:
deleting all account/character Logs.
deleting all clan members of his clan(in case hes leader).
deleting his clan.
deleting all his characters.
deleting account from Login and account table.

 

[Vusion]

Guys what he means is emptying the whole table not deleting it.

 

[Demantor]

DELETE FROM [Table Name]