达梦DM 8数据库之数据库表操作

1、创建表的SQL表语句如下：CREATE TABLE "DMHR".&孥恶膈茯quot;CITY"( "CITY_ID" CHAR(3) NOT NULL, "CITY_NAME" VARCHAR(40), "REGION_ID" INT, CONSTRAINT "CITY_C_ID_PK" NOT CLUSTER PRIMARY KEY("CITY_ID"), CONSTRAINT "CITY_REG_FK" FOREIGN KEY("REGION_ID") REFERENCES "DMHR"."REGION"("REGION_ID"))STORAGE(ON "MAIN", CLUSTERBTR) ;COMMENT ON COLUMN "DMHR"."CITY"."CITY_NAME" IS '城市名称';

3、插入数据，SQL代码如下：INSERT INTO DMHR.CITY(CITY_ID,CITY_NAME,REGION_ID) VALUES('LA','六安',2);

5、查询创建的表结构，SQL代码如下：select dbms_metadata.get_ddl('TABLE','C朐袁噙岿ITY','DMHR');sp_tabledef('DMHR','CITY');

7、--增加列alter table DMHR.CITY add BZ varchar(18);--删除列alter table DMHR.CITY drop BZ;

9、--删除表drop table DMHR.CITY;