I need a SQLQuery to delete accounts fully
Delete existing characters, delete clans, etc ...
I need a SQLQuery to delete accounts fully
Delete existing characters, delete clans, etc ...
Execute in Microsoft SQL Server.Code:TRUNCATE TABLE Account TRUNCATE TABLE AccountItem TRUNCATE TABLE Character TRUNCATE TABLE CharacterItem TRUNCATE TABLE Clan TRUNCATE TABLE ClanMember TRUNCATE TABLE Friend TRUNCATE TABLE Login
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. :)
According to his post he said he wanted to "delete existing accounts, characters, clans fully"
But his title says SQLQuery to delete account, lol confusing at least you gave it some effort ;3.
i need to delete 1 account :s
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'
Code:DELETE FROM Account WHERE AID='[AID]' DELETE FROM Login WHERE AID='[AID]' DELETE FROM Character WHERE AID='[AID]' DELETE FROM Clan WHERE NAME='[Name]'