如何在SQL Server 2005中快速清除记录(使用alitle脚本)? [英] How to Clear record very fastly ( use alitle script ) in SQL server 2005?

问题描述

当我想清除SQL Server 2005中的记录时，我使用了以下代码:
使用[测试]
GO
从TblAuditTrial删除；
从TblAuditTrialGroup删除；从TblMenu删除
从TblMenuCategory删除
从TblMenuSubCategory删除
从dbo.TblRefund中删除
从dbo.TblReport中删除.从dbo.TblStockOutGross中删除.从dbo.TblUnit中删除.TblUnit
从dbo.TblUser中删除. >从dbo.TblUserGroup删除
从dbo.TblUserGroupPermission删除
从dbo.TblVoidOrder删除
从dbo.TblVoidStockIn删除
从dbo.TblVoidStockOut删除从dbo.TlkpNext
从dbo.TlkpPermissionCategory删除
从dbo.TrelBranchUser删除对我来说容易，cos我必须下很多..
有人可以给我一些简单的方法吗?我是新学习者，谢谢..

when i want to Clear my record in SQL server 2005 i used this code:
USE [Test]
GO
DELETE FROM TblAuditTrial;
DELETE FROM TblAuditTrialGroup;
DELETE FROM TblGrossProfit
DELETE FROM TblMenu
DELETE FROM TblMenuCategory
DELETE FROM TblMenuSubCategory
DELETE FROM TblOrderDetail
DELETE FROM TblOrderStatus
DELETE FROM TblPayment
DELETE FROM TblPaymentDetail
DELETE FROM dbo.TblProject
DELETE FROM dbo.TblRefund
DELETE FROM dbo.TblReport
DELETE FROM dbo.TblReportGroup
DELETE FROM dbo.TblStockOutGross
DELETE FROM dbo.TblUnit
DELETE FROM dbo.TblUser
DELETE FROM dbo.TblUserGroup
DELETE FROM dbo.TblUserGroupPermission
DELETE FROM dbo.TblUtilities
DELETE FROM dbo.TblVoidOrder
DELETE FROM dbo.TblVoidStockIn
DELETE FROM dbo.TblVoidStockOut
DELETE FROM dbo.TlkpNext
DELETE FROM dbo.TlkpPermissionCategory
DELETE FROM dbo.TrelBranchUser
DELETE FROM dbo.TlkpPermission
Go



It''s is not easy for me, cos i must drop down alot ..
Can any one give me some easy way? i''m a new Learner, thanks..

推荐答案

使用此
从information_Schema.columns

or
EXEC sp_MSForEachTable从?删除?"
EXEC sp_MSForEachTable"TRUNCATE TABLE?"

use this
select distinct ''delete from ''+ Table_Name from information_Schema.columns

or
EXEC sp_MSForEachTable ''DELETE FROM ?''
EXEC sp_MSForEachTable ''TRUNCATE TABLE ?''

这篇关于如何在SQL Server 2005中快速清除记录(使用alitle脚本)?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！