如何建立“学生管理”数据库，并在“学生管理”数据库中分别建立“学生基本情况表”求高手教一下

USE [master]

GO

CREATE DATABASE StudentManage ON PRIMARY

( NAME = N'StudentManage', FILENAME = N'D:\StudentManagemdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )

LOG ON

( NAME = N'StudentManage_log', FILENAME = N'D:\StudentManage_logldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)

GO

/学生管理数据库（StudentManage）创建完成，下面创建学生表（Student）：/

USE [Jinlong]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo][Student](

[学号C9] [char](7) NOT NULL,

[姓名C10] [char](6) NULL,

[性别C2] [char](2) NULL,

CONSTRAINT [PK_Student] PRIMARY KEY CLUSTERED

(

[SID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

if exists (select from dbosysobjects where id = object_id(N'[dbo][CangKu]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo][CangKu]

GO

CREATE TABLE [dbo][成绩] (

[学号] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[科目] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,

) ON [PRIMARY]

GO

以上就是关于如何建立“学生管理”数据库，并在“学生管理”数据库中分别建立“学生基本情况表”求高手教一下全部的内容，包括:如何建立“学生管理”数据库，并在“学生管理”数据库中分别建立“学生基本情况表”求高手教一下、用SQL语言创建学生成绩数据库的代码、等相关内容解答，如果想了解更多相关内容，可以关注我们，你们的支持是我们更新的动力！