A Question about MSSQL.

[Phoenix]

I want to reset all the accounts and characters in my database such that it seemed that they never existed. I want the AID's to start from 1 again , CharacterItem.dbo and all other Character info to be deleted. Could someone tell me how I could do so?

[MentaL]

[Linear88]

Delete the tables, and recreate them with the queries provided in the server tutorial.

It should reset the AID(s).

[wesman2232]

DELETE * FROM Account
DELETE * FROM Character
I'm not sure about the AIDs

[Linear88]

DELETE * FROM Account
DELETE * FROM Character
I'm not sure about the AIDs

The AID count would not reset that way.

Just drop the tables, and recreate them.

DROP TABLE Account
DROP TABLE Character

[Phoenix]

I tried that query on both Tables Linear88, but it say's the table's are being used by a Foreign Key. And those key's dont even get deleted. Sorry, Idk MSSQL. What do I do?

[Linear88]

I tried that query on both Tables Linear88, but it say's the table's are being used by a Foreign Key. And those key's dont even get deleted. Sorry, Idk MSSQL. What do I do?

Drop the other tables which are preventing it from being dropped.

Example:

If you see:
FK1_ITEM_92328340

Where:
randomidentifier_tablename_randomid

DROP TABLE tablename

[Phoenix]

I dont get it

[Linear88]

Look into it. That's all.

[Phoenix]

[Linear88]

Never mind, just execute this into a query:

DROP TABLE AccountItem
DROP TABLE ClanGameLog
DROP TABLE ClanMember
DROP TABLE GameLog
DROP TABLE Item
DROP TABLE Login
DROP TABLE Account

I won't go much into detail, but;

If it doesn't work, just find out what's interfering with the statements provided.

[Phoenix]

I cant delete Item.dbo! All the cash item's are in it lol. Each and every x_x

---------- Post added at 03:58 PM ---------- Previous post was at 03:50 PM ----------

='(

[Phoenix]

Anyone :'(?

[Linear88]

Remove the foreign key constraints, however, it may cause problems.