收缩数据库

USE master
GO
IF EXISTS(SELECT name FROM sys.databases WHERE name=N'Test')
DBCC SHRINKDATABASE(N'Test')
GO

编程技巧