CREATE DATABASE SPJ
ON PRIMARY
( NAME=SPJ,
FILENAME="C:\DATABASES\SPJ.mdf",
SIZE=5,MAXSIZE=unlimited,
FILEGROWTH=10%)
LOG ON
(NAME=SPJ_LOG,
FILENAME="C:\DATABASES\SPJ.ldf",
SIZE=1,MAXSIZE=5,
FILEGROWTH=1) //创建数据库
USE SPJ; //使用数据库
go
CREATE TABLE S //建表
(SNO CHAR(3)NOT NULL PRIMARY KEY, //设置主键约束,非空
SNAME CHAR(10),
STATUS CHAR(2),
CITY CHAR(10));
CREATE TABLE P
(PNO CHAR(3)NOT NULL PRIMARY KEY,
PNAME CHAR(10),
COLOR CHAR(6),
WEIGHT INT);
CREATE TABLE J
(JNO CHAR(3)NOT NULL PRIMARY KEY,
JNAME CHAR(10),
CITY CHAR(10));
CREATE TABLE SPJ
(SNO CHAR(3) FOREIGN KEY REFERENCES S(SNO), //设置外键约束
PNO CHAR(3) FOREIGN KEY REFERENCES P(PNO),
JNO CHAR(3) FOREIGN KEY REFERENCES J(JNO),
QTY INT,
PRIMARY KEY(SNO,PNO,JNO)); //设置表级完整性约束
SQL SERVER 2012创建数据库,使用数据库以及建表
最新推荐文章于 2024-03-02 00:10:29 发布