Probaj ovo
Code (sql):DECLARE
@SQL VARCHAR(4000),
@int_counter INT,
@int_max INT
DECLARE @TABLES TABLE(
ident INT IDENTITY(1,1) PRIMARY KEY,
TABLE VARCHAR(256))
INSERT @TABLES(TABLE)
SELECT name FROM sysobjects WHERE xtype = 'U'
SELECT
@int_counter = 1,
@int_max = (SELECT MAX(ident) FROM @TABLES))
WHILE @int_counter <= @int_max
BEGIN
SELECT @SQL = 'DELETE ' + TABLE
FROM @TABLES WHERE ident = @int_counter
SELECT @int_counter = @int_counter + 1
END
Ovo ce raditi samo ako nemas foreign keys i ne zezaj se sa sistemskim bazama(sysobjects), opasno je.
P.S.
Ne odgovaram za posledice ovog skripta :)
ovo sam nasao na dbforumu.