demo028.sql

T-SQL示例大全

/* 文件名称: Demo028.sql */
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'Test')
	DROP DATABASE Test
GO

CREATE DATABASE Test
ON
 (
NAME = N'Test_Data',
FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\data\Test_Data.MDF' ,
SIZE = 1,
FILEGROWTH = 10%
)
LOG ON
(
NAME = N'Test_Log', 
FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\data\Test_Log.LDF',
SIZE = 1,
FILEGROWTH = 10%
)
COLLATE Chinese_Taiwan_Stroke_CI_AS
GO

-- 更改数据库的名称
EXEC sp_renamedb @dbname = 'Test', @newname = '我的范例数据库'
-- EXEC sp_renamedb 'Test', '我的范例数据库'