A Question about MSSQL.

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?

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

It should reset the AID(s).

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

Quote:

---

Originally Posted by wesman2232

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.

Code:

---

DROP TABLE Account
DROP TABLE Character

---

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?

Quote:

---

Originally Posted by phoenix_147

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

Code:

---

DROP TABLE tablename

---

I dont get it

Look into it. That's all.

http://i27.tinypic.com/2nin1v5.jpg

Never mind, just execute this into a query:

Code:

---

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.

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 ----------

='(

http://i28.tinypic.com/2mrh1.jpg

Anyone :'(?

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