Wipe Database

[BeatsByDr.Dre 8]

Hello Everyone,

Just wanted to ask something.
how to wipe a database? 

is there a query code to wipe database without touching the column names? 

[Billy 164]

Truncate table [table name];

[BeatsByDr.Dre 8]

1 hour ago, Billy said:

Truncate table [table name];

Thanks!!

Edited November 24, 2016 by BeatsByDr.Dre

[V3ct0r 2,117]

Hello @BeatsByDr.Dre!

 

Why not take clean database?

[BeatsByDr.Dre 8]

7 minutes ago, V3ct0r said:

Hello @BeatsByDr.Dre!

 

Why not take clean database?

i had a custom database with accounts and characters in it. i forgot where i put my custom database clean. so i cant. i really need to wipe and take a clean backup with it

[Vasil 71]

Hello,since you guys talking about that, may you share a script that doesn't make the database jump after wiping from ID 1 to 11005 for example?

[Billy 164]

https://msdn.microsoft.com/en-us/library/ms176057.aspx

 

seriously, does no one know you can google questions?

[Vasil 71]

2 minutes ago, Billy said:

https://msdn.microsoft.com/en-us/library/ms176057.aspx

 

seriously, does no one know you can google questions?

thanks blue sheep token

[V3ct0r 2,117]

@BeatsByDr.Dre

 

You also have to restore guild table (GameDB.dbo.guild). You can't just truncate it. You need to set all values of every guild to default ones.

[BeatsByDr.Dre 8]

6 hours ago, V3ct0r said:

@BeatsByDr.Dre

 

You also have to restore guild table (GameDB.dbo.guild). You can't just truncate it. You need to set all values of every guild to default ones.

what is the best way to wipe a customized database? 

[Shako 97]

8 hours ago, BeatsByDr.Dre said:

what is the best way to wipe a customized database? 

 

Create an identical copy by sql query

Edited November 26, 2016 by Shako

[BeatsByDr.Dre 8]

1 hour ago, Shako said:

 

Create an identical copy by sql query

by doing that all columns will be in query right? and i will just ok ok got it. thank you!

[wolfenx 106]

USAR ESTA QUERY

USE GameDB
update character set guild_id = 0,guild_stat = 0,guild_permission = 0
delete guild
insert into guild (guild_id,guild_name,type) values(0,'Navy HQ3',0)
insert into guild (guild_id,guild_name,type) values(1,'Navy Division 1',0)
insert into guild (guild_id,guild_name,type) values(2,'Navy Division 2',0)
insert into guild (guild_id,guild_name,type) values(3,'Navy Division 3',0)
insert into guild (guild_id,guild_name,type) values(4,'Navy Division 4',0)
insert into guild (guild_id,guild_name,type) values(5,'Navy Division 5',0)
insert into guild (guild_id,guild_name,type) values(6,'Navy Division 6',0)
insert into guild (guild_id,guild_name,type) values(7,'Navy Division 7',0)
insert into guild (guild_id,guild_name,type) values(8,'Navy Division 8',0)
insert into guild (guild_id,guild_name,type) values(9,'Navy Division 9',0)
insert into guild (guild_id,guild_name,type) values(10,'Navy Division 10',0)
declare @id int
select @id = 11
while @id < 100
begin
    insert into guild (guild_id,guild_name,type) values(@id,'Navy Division '+convert(varchar(2),@id),0)
    select @id =@id +1
end
insert into guild (guild_id,guild_name,type) values(101,'Pirate Guild 1',1)
insert into guild (guild_id,guild_name,type) values(102,'Pirate Guild 2',1)
insert into guild (guild_id,guild_name,type) values(103,'Pirate Guild 3',1)
insert into guild (guild_id,guild_name,type) values(104,'Pirate Guild 4',1)
insert into guild (guild_id,guild_name,type) values(105,'Pirate Guild 5',1)
insert into guild (guild_id,guild_name,type) values(106,'Pirate Guild 6',1)
insert into guild (guild_id,guild_name,type) values(107,'Pirate Guild 7',1)
insert into guild (guild_id,guild_name,type) values(108,'Pirate Guild 8',1)
insert into guild (guild_id,guild_name,type) values(109,'Pirate Guild 9',1)
insert into guild (guild_id,guild_name,type) values(110,'Pirate Guild 10',1)
select @id =111
while @id <200
begin
    insert into guild (guild_id,guild_name,type) values(@id,'Pirate Guild '+convert(varchar(2),@id-100),1)
    select @id =@id +1
end