/*
创建数据库,首先检查要创建的数据库的名字是否已经存在
*/
if db_id(N'test1') is not null/*N的作用是用unicode编码,一个字符占两个字节*/
drop database test1;
go
CREATE DATABASE test1
on
(
name='t',
filename='F:/sqlserver2005.ISO/MicrosoftSQLServer2005简体中文开发版/cs_sql_2005_dev_all_dvd/SQL Server x86/test1.mdf',
/*路径必须是自己在安装软件是设置的*/
size=10mb,
maxsize=100mb,
filegrowth=5mb
)
go
ALTER database test1
add file
(
name='s',filename='F:/sqlserver2005.ISO/MicrosoftSQLServer2005简体中文开发版/cs_sql_2005_dev_all_dvd/SQL Server x86
/jifeng.mdf'
)
/*
create table std_info
(
s_id int primary key,
s_name nvarchar(10) not null,
s_sex nvarchar(2) not null check(s_sex='男' or s_sex='女' ),
s_address nvarchar(20) default('成都市')
)