如何在除一个表之外的语句中从sql server 2005中的数据库中删除所有表

DECLARE @tables TABLE (table_name NVARCHAR(128))

INSERT INTO @tables
SELECT name
FROM sys.tables

DELETE FROM @tables
WHERE table_name = '保留的表名'

DECLARE @table_name NVARCHAR(128)

WHILE (SELECT COUNT(*) FROM @tables) > 0
BEGIN
    SELECT TOP 1 @table_name = table_name FROM @tables

    EXEC('DROP TABLE ' + @table_name)

    DELETE FROM @tables
    WHERE table_name = @table_name
END