注册

达梦数据库怎么创建聚集索引表和非聚集索引表

孤独的熊猫 2026/02/04 444 4 已解决

比如:CREATE TABLE "SYSDBA"."CASE_INFO"
(
"BELONGXIAQUCODE" VARCHAR(50),
"OPERATEUSERNAME" VARCHAR(50),
"OPERATEDATE" TIMESTAMP(6),
"ROW_ID" INT,
"YEARFLAG" VARCHAR(4),
"ROWGUID" VARCHAR(50) NOT NULL,
"OPERATEUSERGUID" VARCHAR(50),
"OPERATEUSEROUGUID" VARCHAR(50),
"OPERATEUSERBASEOUGUID" VARCHAR(50),
"PVIGUID" VARCHAR(50),
"CASE_SERIAL" VARCHAR(50),
"CASE_TITLE" VARCHAR(200),
"CASE_REGISTER" VARCHAR(50),
"CASE_REGISTERNO" VARCHAR(50),
"CASE_DATE" TIMESTAMP(6),
"CASE_SOURCE" VARCHAR(50),
"PHONE_NUMBER" VARCHAR(50),
"APPLICANT_NAME" VARCHAR(50),
"APPLICANT_SEX" VARCHAR(50),
"APPLICANT_AGE" VARCHAR(50),
"APPLICANT_ID" VARCHAR(50),
"CERTIFICATE_TYPE" VARCHAR(50),
"CASE_TYPE" VARCHAR(50),
"CASE_ACCORD" VARCHAR(200 CHAR),
"CASE_ACCORD_CODE" VARCHAR(50),
"CASE_CONTENT" CLOB,
"CASE_PROCESS_TYPE" VARCHAR(50),
"CASE_ISPUBLIC" VARCHAR(50),
"CASE_ISVISIT" VARCHAR(50),
"CASE_ISURGENT" VARCHAR(50),
"SENDOUTIME_BF" TIMESTAMP(6),
"TSIGNTIME_BF" TIMESTAMP(6),
"TFDBACKTIME_BF" TIMESTAMP(6),
"TBACKTIME_BF" TIMESTAMP(6),
"RELATE_SERIAL" VARCHAR(50),
"CASE_LNGLAT" VARCHAR(50),
"CASE_ADDRESS" VARCHAR(200),
"EVENT_DATE" TIMESTAMP(6),
"KNOWLEDGE_NAME_log" VARCHAR(400),
"KNOWLEDGE_GUID_log" VARCHAR(400),
"LINEFLAG" VARCHAR(50),
"FLAG" VARCHAR(50),
"UNIQUE_ID" VARCHAR(50),
"ISBACK" VARCHAR(10),
"IS_DIRECTFINISH" VARCHAR(10),
"BACK_TYPE" VARCHAR(10),
"BACK_REASON" TEXT,
"BUSINESS_TYPE" VARCHAR(10),
"BUSINESS_NAME" VARCHAR(200),
"BUSINESS_CODE" VARCHAR(100),
"BUSINESS_LIFE" VARCHAR(10),
"BUSINESS_TAG" VARCHAR(10),
"OPTIMIZE_BUSINESS_TAG" VARCHAR(10),
"IS_SIGN_OUT" VARCHAR(10),
"IS_FINISH_OUT" VARCHAR(10),
"CSTATUS" VARCHAR(20),
"AREA_CODE" VARCHAR(50),
"ISRESOLVE" VARCHAR(10),
"UPDATETIME" TIMESTAMP(6),
"IS_DELAY" VARCHAR(2),
"IS_ABANDON" VARCHAR(2),
"IS_PUBLISH" VARCHAR(10),
"IS_ASSESSMENT" VARCHAR(10),
"IS_SUPERVISE" VARCHAR(10),
"PROJECTAPPROVAL" VARCHAR(20),
"BLZ_PROJECT" VARCHAR(20),
"PROJECT_STATUS" VARCHAR(10),
"DATACHANGE_TIME" TIMESTAMP(6),
"CINFOFINISHTIME" TIMESTAMP(6),
"time_stamp" TIMESTAMP(6) DEFAULT SYSDATE,
"TSIGNTIME_BFMS" TIMESTAMP(6),
"KNOWLEDGE_NAME" TEXT,
"KNOWLEDGE_GUID" TEXT,
"CHECK_STAUS" VARCHAR2(20) DEFAULT 0,
"CK_PERSONGUID" VARCHAR2(50),
"DIST_TIME" DATETIME(6),
"CK_PERSON" VARCHAR2(50),
"PERSONNAME" VARCHAR(100),
"PERSONIDCARD" VARCHAR(20),
"PERSONIDNUMBER" VARCHAR(50),
"PERSONIDVALIDDATE" VARCHAR(50),
"OLDCORPNAME" VARCHAR(100),
"NEWCORPNAME" VARCHAR(100),
"OLDCORPIDCARD" VARCHAR(20),
"NEWCORPIDCARD" VARCHAR(20),
"OLDCORPMOBILE" VARCHAR(20),
"NEWCORPMOBILE" VARCHAR(20),
"OLDAGENTNAME" VARCHAR(100),
"NEWAGENTNAME" VARCHAR(100),
"OLDAGENTIDCARD" VARCHAR(20),
"NEWAGENTIDCARD" VARCHAR(20),
"OLDAGENTMOBILE" VARCHAR(20),
"NOTES" VARCHAR(1000),
"CASE_DEAL_AREACODE" VARCHAR(50),
"NEWAGENTMOBILE" VARCHAR(20),
"CASE_CONTENT_SUPPLY" VARCHAR(2000),
"transfer_number" VARCHAR2(50),
"noeffectivetype" VARCHAR2(80),
"handletimelong" DECIMAL(10,2),
"transfermark" VARCHAR2(1),
"WDRW" VARCHAR2(50),
"TYDSC" VARCHAR2(50),
"PLATENUMBER" VARCHAR2(10),
"RESULTTYPE" VARCHAR2(2),
"ggzyjyzxzz" VARCHAR2(10),
"RQSTSOURCETO" VARCHAR2(50),
"ZZQCASE_SERIAL" VARCHAR2(50),
"YSHJ_FOUR" VARCHAR(20),
"istworeponecom" VARCHAR(2),
"tworeponecomtype" VARCHAR(20),
"SUPERVISE_TIME" TIMESTAMP(6),
"BUSINESS_DETAIL" VARCHAR(50),
CONSTRAINT "SYSDBA_CASE_INFO" NOT CLUSTER PRIMARY KEY("ROWGUID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

回答 0
暂无回答
扫一扫
联系客服