想把数据库的号都清空， 但又不知道怎么删除！ 有一些语句 又不知怎么用。
truncate table account_char
go
truncate table currentuser
go
truncate table deleted_userdata
go
truncate table knights
go
truncate table knights_rating
go
truncate table knights_user
go
truncate table tb_user
go
truncate table userdata
go
truncate table USERDATA_SKILLSHORTCUT
go
truncate table KNIGHTS_ALLIANCE
go
truncate table BK_FRI_USERDATA
go
truncate table BK_MON_USERDATA
go
truncate table BK_SAT_USERDATA
go
truncate table BK_SUN_USERDATA
go
truncate table BK_THU_USERDATA
go
truncate table BK_TUE_USERDATA
go
truncate table BLOCKED_USERDATA
go
truncate table USER_EDITOR_ITEM
go
truncate table PREMIUM_SERVICE
go
truncate table WAREHOUSE
go
truncate table ELMO_RANK
go
truncate table KARUS_RANK
go
truncate table USER_SAVED_MAGIC
go
truncate table HACKTOOL_USERLOG
go
truncate table HERO_USER
go
truncate table DUPE_CHECK
go
truncate table LEVEL_CHART
go
truncate table LEVEL_CHART_WED
go
这些有用不? 怎么用？ 谢告诉下。。。 |
