黑马程序员--SQL入门基础知识二--DDL语句

---------------------- android培训、java培训、期待与您交流！ ----------------------
DDL(Data Definition Language数据定义语言)

包括Create、Drop、Alter

已创建数据库为例

1)创建数据库

create Database MySchool                                --MySchool是数据库名称

[on primary

(

[name=MySchool,]                                                 --MySchool数据库文件逻辑名称

filename='D:\MyData\MySchool.mdf',                 --'D:\MyData\MySchool.mdf''物理文件名称

[size=5mb,]                                                             --初始文件大小

[filegrowth=1mb]                                                    --文件每次增量

[log on

(

[name=MySchoolLog,]                                          --MySchoolLog日志文件逻辑名称

filename='D:\MyData\MySchoolLog.ldf',             --'D:\MyData\MySchoolLog.ldf''物理文件名称

[size=10mb,]                                                           --初始文件大小

[filegrowth=10%]                                                    --文件每次增量

[maxsize=100mb]

)

go

2)修改数据库

Alter Database MySchool

Add File

(

[name=MySchool1,]                                                 

filename='D:\MyData\MySchool1.mdf',                

[size=10mb,]                                                            

[filegrowth=3mb]  

)

go

Alter Database MySchool

Add Log File

(

[name=MySchoolLog1,]                                          

filename='D:\MyData\MySchoolLog1.ldf',            

[size=5mb,]                                                          

[filegrowth=2mb]                                                   

)

3)删除数据库

Drop Database MyShool

---------------------- android培训、 java培训、期待与您交流！ ----------------------详细请查看： http://edu.csdn.net/heima