SQL SERVER 2012创建数据库，使用数据库以及建表

来源：互联网发布：手机pdf朗读软件编辑：程序博客网时间：2024/05/01 10:09

CREATE DATABASE SPJON 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));                   //设置表级完整性约束

0 0