数据库
Create database product order system create database LovelyBaby_system on primary
( name = LovelyBaby_system,
filename ='C:\data\LovelyBaby_system.mdf', size =3,
filegrowth =25%) log on
( name = product_order_system_log,
filename ='c:\data\LovelyBaby_system_log.ldf', size =10MB,

filegrowth =2MB)
2. Create table
CREATE TABLE Supplier (
Supplier_ID int primary key
IDENTITY(1,1)
NOT NULL,
Name varchar(250) NULL, Address varchar(250) NULL, Phone varchar(25) NULL, Fax varchar(25) NULL, ConstactPerson varchar(20) NULL ) go
CREATE TABLE Customer (
Customer_ID int primary key
IDENTITY(1,1)
NOT NULL,
Name varchar(250) NULL, Address varchar(250) NULL, Phone varchar(25) NULL, Fax varchar(25) NULL, ConstactPerson varchar(20) NULL ) go
Create Table 语法 15页 免费 CREATE TABLE句法 8页 2财富值 CREATE table 1 暂无评价 4页 免费 CREATE TABLE T 暂无评价 4页 免费 CREATE TABLE Supplier ...
() SQL> create table supplier (s_code NUMBER(6), sname VARCHAR2(25), contact VARCHAR2(15), phone VARCHAR2(15), fax VARCHAR2(15)); 1.12 SQL...
在数据库 market 中创建表: customer、 supplier、 goods、 orders、 creditgrate 和 goodstype 对于 customer 表 建表语句如下: Create table customer (C_id ...
Create table OrderItem 第 8 页共 16 页 (ono varchar(20), Pno varchar...创建包含给出的字段和约束的 supplier 表。 Field Scode Sname Status City ...
(10) not null 解:create table supplier ( Scode char(2) constraint PK_Scode primary key, Sname varchar(10) constraint EMP_name NOT NULL, Status ...
(material_no), ) --供应商表 create table supplier ( supplier_no varchar(10), material_no varchar(10), supplier_name varchar(10)not null, supplier_...
4.2.2 输入 CREATE TABLE 语句创建表下面将使用 CREATE TABLE 语句创建 market 数据库中的主要表:customer、supplier、 goods、order、creditgrade、goodtype 等。...
create sequence part_su start with 1 increment by 1; create sequence spp_su start with 1 increment by 1; --创建供应商表 create table supplier( sno...
解: CREATE SCHEMA Supplier_schema CREATE TABLE Supplier ( Sno Sname Phone Address ); CREATE SCHEMA Part_schema CREATE TABLE Part ( Pno Pname Color ...
供应商信息表 Supplier */ /*===*/ create table Supplier ( 1 SupplierID SupplierName Phone Address PostalCode City char(5) varchar(50) varchar(20) va...
热门文档