Deleting character info from all tables

[LastThief]

Hey guys how're you doing ? So yea that will be needed in my next SQL engine

The theory is (DELETE FROM _Char WHERE DELETED = '1') but infact there is another tables which stores character info also what are those tables ? what are the relation ships between them ?

Looking forward for answers :)

Ciao,
LastThief

[MentaL]

[egsro]

what about moving characters from one to anther !

[IMOS]

you can check the table dependencies.

[egsro]

Ooh Here you are :-p
use SRO_VT_SHARD
delete from [dbo].[_InvCOS]
delete from [dbo].[_CharCOS]
delete from [dbo].[_CharTrijob]
delete from [dbo].[_CharSkill]
delete from [dbo].[_CharSkillMastery]
delete from [dbo].[_Inventory]
delete from [dbo].[_Char]

have fun

[megaman963]

Hey guys how're you doing ? So yea that will be needed in my next SQL engine

The theory is (DELETE FROM _Char WHERE DELETED = '1') but infact there is another tables which stores character info also what are those tables ? what are the relation ships between them ?

Looking forward for answers :)

Ciao,
LastThief

Check Foreign Key between Table _Char and other table ...
and you will know what are these tables ..

Good luck

BE COOOOOOL !!