面向对象程序设计课件2.ppt

3.3.2 创建用户数据库 用SQL命令创建数据库 CREATE DATABASE database_name [ ON [ filespec [ ,...n ] ] [ , filegroup [ ,...n ] ] ] [ LOG ON { filespec [ ,...n ] } ] [ COLLATE collation_name ] [ FOR LOAD | FOR ATTACH ] 修改用户数据库 用SQL命令修改数据库 ALTER DATABASE database_name { ADD FILE filespec [,...n] [TO FILEGROUP filegroup_name] | ADD LOG FILE filespec [,...n] | REMOVE FILE logical_file_name [WITH DELETE] | ADD FILEGROUP filegroup_name | REMOVE FILEGROUP filegroup_name | MODIFY FILE filespec | MODIFY NAME = new_dbname | MODIFY FILEGROUP filegroup_name {filegroup_property | NAME = new_fi