----查询数据库文件大小
SELECT top 1 DB_NAME(database_id) AS [Database Name],[Name] AS [Logical Name],
[Physical_Name] AS [Physical Name],((size * 8) / 1024) AS [Size(MB)],size,
[differential_base_time] AS [Differential Base Time]
FROM sys.master_files where DB_NAME(database_id) = 'MedicalTemp' order by [file_id] desc
----创建数据库,添加一个组文件
alter database Medicaltemp --指定要修改的数据库
add file --增加数据文件
(name=Medicaltemp3, --文件在数据库中的名字,
filename='E:\Medicaltemp3.mdf',--文件路径和在文件系统中的名字
size=2MB, --文件初始大小
maxsize=1536MB, --文件上限
filegrowth=10% --增量
)
---删除表
declare @result VARCHAR(30)
Declare curStudentFee Cursor for
SELECT NAME FROM SysObjects where XType = 'U';
Open curStudentFee
Fetch Next From curStudentFee Into @result
While ( @@Fetch_Status=0 )
begin
exec ('drop table'+@result)
Fetch Next From curStudentFee into @result
end
Close curStudentFee
Deallocate curStudentFee