oracle创建表语句

前端之家收集整理的这篇文章主要介绍了oracle创建表语句前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

以下是两个简单的创建案例:

create table "pc_pp_product"
(
"phone_id" VARCHAR2(32 BYTE) NOT NULL ENABLE,--主键
"color" VARCHAR2(32 BYTE),
"phone_type" VARCHAR2(32 BYTE),
"weidth" VARCHAR2(32 BYTE),
"length" VARCHAR2(32 BYTE),
"price" VARCHAR2(32 BYTE),
"category" VARCHAR2(32 BYTE),
CONSTRAINT "phone_id1445" PRIMARY KEY ("phone_id")
);
COMMENT ON COLUMN "pc_pp_product"."phone_id" IS '产品表主键';
COMMENT ON COLUMN "pc_pp_product"."color" IS '颜色';
COMMENT ON COLUMN "pc_pp_product"."phone_type" IS '型号';
COMMENT ON COLUMN "pc_pp_product"."weidth" IS '宽度';
COMMENT ON COLUMN "pc_pp_product"."length" IS '大小';
COMMENT ON COLUMN "pc_pp_product"."price" IS '价格';
COMMENT ON COLUMN "pc_pp_product"."category" IS '类别';

/** =================================================== */

create table "pc_pp_product_class" ( "pc_pp_product_class_id" VARCHAR2(32 BYTE) NOT NULL ENABLE,--主键 "pc_pp_product_class_code" VARCHAR2(32 BYTE),"pc_pp_product_class_name" VARCHAR2(32 BYTE),CONSTRAINT "pc_pp_product_class_id123" PRIMARY KEY ("pc_pp_product_class_id") ); COMMENT ON COLUMN "pc_pp_product_class"."pc_pp_product_class_id" IS '产品类型表主键'; COMMENT ON COLUMN "pc_pp_product_class"."pc_pp_product_class_id" IS '编号'; COMMENT ON COLUMN "pc_pp_product_class"."pc_pp_product_class_id" IS '名称';

原文链接:https://www.f2er.com/oracle/213229.html

猜你在找的Oracle相关文章