SQL数据库的基本操作
use master
go
--创建“L-C”模式
create schema "L-C" AUTHORIZATION dbo;
--drop schema "L-C";
--创建数据库
create database db_Library
--drop database db_Library
ON primary
(
NAME=N'DB_Library_data',
FILENAME=N'D:\MySQL\DB_Library_data.mdf',
SIZE=10MB,
MAXSIZE=100MB,
FILEGROWTH=10%
)
LOG ON
(
NAME=N'DB_Library_log',
FILENAME=N'D:\MySQL\DB_Library_log.ldf',
size=5MB,
maxsize=200MB,
filegrowth=2MB
)
create table tb_course
(
KC_number INT primary key,
KC_Bianhao INT,
XianXiu_KC CHAR(9),
KC_XueFen INT
);