创建及删除表.pptVIP

2.创建及删除表 p86 1 创建新表的基本语法： CREATE TABLE [database_name.[ owner ] .| owner.] table_name column_name data_type [ [ DEFAULT constant_expression ]|[ IDENTITY [ seed,increment ]]?] [ROWGUIDCOL] ? [ NULL | NOT NULL ] [ PRIMARY KEY | UNIQUE?] [ ,...n ] ] 1 创建新表的基本语法： CREATE TABLE [database_name.[ owner ] .| owner.] table_name column_name data_type [ [ DEFAULT constant_expression ]|[ IDENTITY [ seed,increment ]]?] [ROWGUIDCOL] ? [ NULL | NOT NULL ] [ PRIMARY KEY | UNIQUE?] [ ,...n ] ] 1 创建新表的基本语法： CREATE TABLE [database_name.[ owner ] .| owner.] table_name column_name data_type [ [ DEFAULT constant_expression ]|[ IDENTITY [ seed,increment ]]?] [ROWGUIDCOL] ? [ NULL | NOT NULL ] [ PRIMARY KEY | UNIQUE?] [ ,...n ] ] 1 创建新表的基本语法： CREATE TABLE [database_name.[ owner ] .| owner.] table_name column_name data_type [ [ DEFAULT constant_expression ]|[ IDENTITY [ seed,increment ]]?] [ROWGUIDCOL] ? [ NULL | NOT NULL ] [ PRIMARY KEY | UNIQUE?] [ ,...n ] ] 1 创建新表的基本语法： CREATE TABLE [database_name.[ owner ] .| owner.] table_name column_name data_type [ [ DEFAULT constant_expression ]|[ IDENTITY [ seed,increment ]]?] [ROWGUIDCOL] ? [ NULL | NOT NULL ] [ PRIMARY KEY | UNIQUE?] [ ,...n ] ] 举例： Creat Table AppDta.dbo.Customer 在本例中，建立新表的数据库为AppDta，所有者为dbo 默认用户名 ，新建表为Customer。使用小圆点“.”作为限定名称的分隔符。 Creat Table Customer 如果省略了数据库名称，就会在当前数据库中创建表。 通常在Use语句中指定数据库。 Use AppDta Go Creat Table Customer 总结：数据库表名称的3种设置格式： 格式一：CREATE TABLE AppDta.dbo.Customer 格式二：CREATE TABLE AppDta.Customer 格式三：CREATE TABLE Customer 1 创建新表的基本语法： CREATE TABLE [database_name.[ owner ] .| owner.] table_name column_name data_type [ [ DEFAULT constant_expression ]|[ IDENTITY [ seed,increment ]]?] [ROWGUIDCOL] ? [ NULL | NOT NULL ] [ PRIMARY KEY | UNIQUE?] [ ,...n ] ] 1 创建新表的基本语法： CREATE TABLE [database_name.[ owner ] .| owner.] table_name column_name data_type [ [ DEFAULT constant_expression ]|[ IDENTITY [ seed,increment ]]?] [ROWGUIDCOL] ? [ NULL | NOT NULL ]