[第章数据库逻辑设计与物理设计.pptVIP

CREATE DATABASE jwgl2 ON PRIMARY( NAME=jwgl2_data, FILENAME=d:\mydata\jwgl2_data.mdf, SIZE=10, MAXSIZE=15, FILEGROWTH=20%) LOG ON( NAME=jwgl2_log, FILENAME=d:\mydata\jwgl2_log.ldf, SIZE=3, MAXSIZE=5, FILEGROWTH=1) Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 8.4 数据定义语言 一、数据库与表的定义 2、删除数据库 DROP DATABASE 数据库名 [,…n] DROP DATABASE jwgl2 3、数据库修改 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 8.4 数据定义语言 一、数据库与表的定义 3、数据库修改 ALTER DATABASE