[TOC] # DDL 目前 OceanBase 数据库对于大部分常用的 DDL 操作都是支持的，并且对于所有支持的 DDL 操作也都是 OnLine 的，在执行 DDL 的过程中不会阻塞业务的读写操作。 <table data-tag="table" id="table-xpw-zpp-a0t" class="table"><colgroup width="254" data-tag="col" id="col-1xv-yhr-zrv" colwidth="1*" colnum="1" colname="col1" style="width:25%" class="col"></colgroup><colgroup width="98" data-tag="col" id="col-ias-nt7-kye" colwidth="1*" colnum="2" colname="col2" style="width:25%" class="col"></colgroup><colgroup width="118" data-tag="col" id="col-j1i-l6h-66d" colwidth="1*" colnum="3" colname="col3" style="width:25%" class="col"></colgroup><colgroup width="146" data-tag="col" id="col-2nh-x0o-eiy" colwidth="1*" colnum="4" colname="col4" style="width:25%" class="col"></colgroup><thead id="thead-kct-yem-jy6" class="thead"><tr id="tr-twy-x5e-ov0"><th id="td-w3p-s07-coi"><p id="p-d8e-k29-f9j"><b>操作</b></p></th><th id="td-kn0-9o0-uwq"><p id="p-y14-mj2-iig"><b>是否支持</b></p></th><th id="td-5bn-trf-6k6"><p id="p-9rl-brv-k6q"><b>是否 ONLINE</b></p></th><th id="td-eq1-yy3-qgz"><p id="p-xip-ukf-u5e"><b>是否重写数据</b></p></th></tr></thead><tbody data-tag="tbody" id="tbody-1bn-bu7-vqa" class="tbody"><tr data-tag="tr" id="tr-sde-gb9-23k" class="tr"><td data-tag="td" id="td-bgf-ixb-0fl" class="td"><p data-tag="p" id="p-fpa-ypo-ytw" class="p">创建/添加索引</p></td><td data-tag="td" id="td-l34-zuq-gu0" class="td"><p data-tag="p" id="p-t9s-z09-z6p" class="p">是</p></td><td data-tag="td" id="td-ptg-bkw-spk" class="td"><p data-tag="p" id="p-cm6-o3h-gqg" class="p">是</p></td><td data-tag="td" id="td-m87-mgn-543" class="td"><p data-tag="p" id="p-ztl-x8l-06b" class="p">是</p></td></tr><tr data-tag="tr" id="tr-vli-7zr-wh6" class="tr"><td data-tag="td" id="td-fs6-cy6-4qt" class="td"><p data-tag="p" id="p-2n5-qg7-jg8" class="p">删除索引</p></td><td data-tag="td" id="td-fdf-tgr-np0" class="td"><p data-tag="p" id="p-m89-d6t-2jt" class="p">是</p></td><td data-tag="td" id="td-a6r-ud2-kgg" class="td"><p data-tag="p" id="p-z50-k14-rhu" class="p">是</p></td><td data-tag="td" id="td-q4a-del-de1" class="td"><p data-tag="p" id="p-hqj-lj3-hnc" class="p">否</p></td></tr><tr data-tag="tr" id="tr-zr3-rro-duv" class="tr"><td data-tag="td" id="td-9p6-n6d-o0h" class="td"><p data-tag="p" id="p-98r-hqf-ejk" class="p">重命名索引</p></td><td data-tag="td" id="td-l4x-ocm-2f6" class="td"><p data-tag="p" id="p-xd8-uof-mqn" class="p">是</p></td><td data-tag="td" id="td-aee-biu-e2m" class="td"><p data-tag="p" id="p-9ky-k5u-tj1" class="p">是</p></td><td data-tag="td" id="td-s1n-qem-fc2" class="td"><p data-tag="p" id="p-j89-8ln-yer" class="p">否</p></td></tr><tr data-tag="tr" id="tr-yoj-ezv-veh" class="tr"><td data-tag="td" id="td-el1-7hg-lgm" class="td"><p data-tag="p" id="p-xot-t48-u8b" class="p">添加全文索引</p></td><td data-tag="td" id="td-k99-hr5-2mj" class="td"><p data-tag="p" id="p-sny-p5o-tuo" class="p">否</p></td><td data-tag="td" id="td-z6l-dyw-s01" class="td"><p data-tag="p" id="p-6vj-895-51x" class="p">-</p></td><td data-tag="td" id="td-lmt-uip-wik" class="td"><p data-tag="p" id="p-qgc-rzx-dpz" class="p">-</p></td></tr><tr data-tag="tr" id="tr-g8g-p1x-1gd" class="tr"><td data-tag="td" id="td-uwu-khp-ybv" class="td"><p data-tag="p" id="p-mjt-4yo-t9w" class="p">添加空间索引</p></td><td data-tag="td" id="td-l18-nbb-onf" class="td"><p data-tag="p" id="p-u21-qo3-igp" class="p">否</p></td><td data-tag="td" id="td-78x-pml-3v1" class="td"><p data-tag="p" id="p-mtx-e9w-s7j" class="p">-</p></td><td data-tag="td" id="td-38k-1aw-wxe" class="td"><p data-tag="p" id="p-crr-y56-nac" class="p">-</p></td></tr><tr data-tag="tr" id="tr-r12-25a-hg2" class="tr"><td data-tag="td" id="td-f3l-rvx-x74" class="td"><p data-tag="p" id="p-0ag-94q-9ax" class="p">添加主键</p></td><td data-tag="td" id="td-f8k-lxh-gh1" class="td"><p data-tag="p" id="p-3zk-p1i-rag" class="p">否</p></td><td data-tag="td" id="td-5ni-uq4-94g" class="td"><p data-tag="p" id="p-7hx-g5w-4jm" class="p">-</p></td><td data-tag="td" id="td-994-rr6-q54" class="td"><p data-tag="p" id="p-d50-8gx-287" class="p">-</p></td></tr><tr data-tag="tr" id="tr-nm7-kvh-lr4" class="tr"><td data-tag="td" id="td-u14-13s-8js" class="td"><p data-tag="p" id="p-7xu-4hy-tk1" class="p">删除主键</p></td><td data-tag="td" id="td-gb3-l8q-s5i" class="td"><p data-tag="p" id="p-p1d-xdh-u0a" class="p">否</p></td><td data-tag="td" id="td-zjj-c2t-ga5" class="td"><p data-tag="p" id="p-kd7-65v-rm9" class="p">-</p></td><td data-tag="td" id="td-5db-uwy-krr" class="td"><p data-tag="p" id="p-eob-euw-tsj" class="p">-</p></td></tr><tr data-tag="tr" id="tr-wc9-m6b-666" class="tr"><td data-tag="td" id="td-rl4-s7k-8dx" class="td"><p data-tag="p" id="p-xs8-x3o-suj" class="p">删除主键并添加新的主键</p></td><td data-tag="td" id="td-ztx-05s-e9t" class="td"><p data-tag="p" id="p-p2v-pmq-3vl" class="p">否</p></td><td data-tag="td" id="td-6vy-knr-zoq" class="td"><p data-tag="p" id="p-658-850-0sl" class="p">-</p></td><td data-tag="td" id="td-ain-995-iop" class="td"><p data-tag="p" id="p-aql-8xz-9ph" class="p">-</p></td></tr><tr data-tag="tr" id="tr-lxi-i5b-rqb" class="tr"><td data-tag="td" id="td-pb0-tbh-xy5" class="td"><p data-tag="p" id="p-v2e-415-guh" class="p">加列</p></td><td data-tag="td" id="td-7c1-juj-v4g" class="td"><p data-tag="p" id="p-sqc-owv-z6z" class="p">是</p></td><td data-tag="td" id="td-op7-4r6-y8f" class="td"><p data-tag="p" id="p-sh3-gdt-0jg" class="p">是</p></td><td data-tag="td" id="td-j0k-ppn-mcv" class="td"><p data-tag="p" id="p-wkh-u70-cvc" class="p">是</p></td></tr><tr data-tag="tr" id="tr-0yk-xl9-gpy" class="tr"><td data-tag="td" id="td-ajj-wq7-w16" class="td"><p data-tag="p" id="p-mx5-8go-1gp" class="p">删列</p></td><td data-tag="td" id="td-wfr-ehv-6tx" class="td"><p data-tag="p" id="p-ie8-376-bhk" class="p">是</p></td><td data-tag="td" id="td-k6n-vt8-qwn" class="td"><p data-tag="p" id="p-u5n-ti4-vw4" class="p">是</p></td><td data-tag="td" id="td-4j7-c3k-22n" class="td"><p data-tag="p" id="p-qz3-olr-et6" class="p">是</p></td></tr><tr data-tag="tr" id="tr-wcj-qqx-49q" class="tr"><td data-tag="td" id="td-hba-xwi-upy" class="td"><p data-tag="p" id="p-9ms-0kz-i8q" class="p">重命名列</p></td><td data-tag="td" id="td-2pr-iji-ehl" class="td"><p data-tag="p" id="p-q7c-1jl-o9v" class="p">是</p></td><td data-tag="td" id="td-jjm-4o7-fr7" class="td"><p data-tag="p" id="p-8wv-x8i-hsv" class="p">是</p></td><td data-tag="td" id="td-83b-rup-93n" class="td"><p data-tag="p" id="p-mw7-ioh-we4" class="p">否</p></td></tr><tr data-tag="tr" id="tr-zmy-510-3lv" class="tr"><td data-tag="td" id="td-o7l-ovi-z2f" class="td"><p data-tag="p" id="p-pmd-bmi-7ix" class="p">修改列的排列顺序</p></td><td data-tag="td" id="td-xuj-lie-ors" class="td"><p data-tag="p" id="p-48c-rcn-tbb" class="p">是</p></td><td data-tag="td" id="td-uil-f16-hrh" class="td"><p data-tag="p" id="p-bkw-qu3-f52" class="p">是</p></td><td data-tag="td" id="td-inb-zqd-7u8" class="td"><p data-tag="p" id="p-4jo-685-qrw" class="p">否</p></td></tr><tr data-tag="tr" id="tr-y9y-1e1-izc" class="tr"><td data-tag="td" id="td-z2s-g4w-0cw" class="td"><p data-tag="p" id="p-a0s-co6-yy2" class="p">修改列默认值</p></td><td data-tag="td" id="td-ttu-0br-f3j" class="td"><p data-tag="p" id="p-ify-isu-gye" class="p">是</p></td><td data-tag="td" id="td-m0x-dfc-knx" class="td"><p data-tag="p" id="p-fbo-fni-rhp" class="p">是</p></td><td data-tag="td" id="td-t1v-wc5-4dw" class="td"><p data-tag="p" id="p-iej-gkx-9qq" class="p">否</p></td></tr><tr data-tag="tr" id="tr-mm4-ai1-69i" class="tr"><td data-tag="td" id="td-pc2-cdm-886" class="td"><p data-tag="p" id="p-3ch-7o3-obv" class="p">修改列类型（兼容类型向上修改）</p><p data-tag="p" id="p-ufk-4ia-tmw" class="p">例如 int 改 bigint、varchar 改 text、blob 改 long blob 等</p></td><td data-tag="td" id="td-5x7-hkr-u8r" class="td"><p data-tag="p" id="p-jo4-uld-f1w" class="p">是</p></td><td data-tag="td" id="td-lzg-ofx-3z6" class="td"><p data-tag="p" id="p-axd-vjr-08b" class="p">是</p></td><td data-tag="td" id="td-yr3-grj-rmu" class="td"><p data-tag="p" id="p-8jp-ctp-xxr" class="p">是</p></td></tr><tr data-tag="tr" id="tr-jnw-g95-bpj" class="tr"><td data-tag="td" id="td-26f-d0q-5f2" class="td"><p data-tag="p" id="p-vzr-vw1-sio" class="p">修改列类型（不兼容类型修改）</p><p data-tag="p" id="p-7y6-wlw-faa" class="p">例如 int 改 varchar、char 改 varchar 等</p></td><td data-tag="td" id="td-p15-pam-f2s" class="td"><p data-tag="p" id="p-3hi-d1x-jug" class="p">否</p></td><td data-tag="td" id="td-1j8-q0q-7va" class="td"><p data-tag="p" id="p-pxg-6bq-e4r" class="p">-</p></td><td data-tag="td" id="td-gkp-uix-0g3" class="td"><p data-tag="p" id="p-p77-nky-y7k" class="p">-</p></td></tr><tr data-tag="tr" id="tr-zxp-iiz-vlt" class="tr"><td data-tag="td" id="td-ftl-ogr-or0" class="td"><p data-tag="p" id="p-m0e-uj7-gwm" class="p">修改列自增列值</p></td><td data-tag="td" id="td-hkm-rum-niw" class="td"><p data-tag="p" id="p-r8c-vrf-cs2" class="p">是</p></td><td data-tag="td" id="td-yhq-s6y-zyt" class="td"><p data-tag="p" id="p-5p9-bua-9u3" class="p">是</p></td><td data-tag="td" id="td-pht-pa1-urp" class="td"><p data-tag="p" id="p-q1g-l4a-zfw" class="p">否</p></td></tr><tr data-tag="tr" id="tr-6l1-ok3-vqi" class="tr"><td data-tag="td" id="td-nux-a1a-pi5" class="td"><p data-tag="p" id="p-1nw-lec-p1y" class="p">设置列约束 NULL</p></td><td data-tag="td" id="td-060-zua-5w5" class="td"><p data-tag="p" id="p-yv6-c2w-5sl" class="p">是</p></td><td data-tag="td" id="td-z2m-b17-gqx" class="td"><p data-tag="p" id="p-edr-jk4-1hi" class="p">是</p></td><td data-tag="td" id="td-gmc-s4t-a4d" class="td"><p data-tag="p" id="p-vov-yak-1cm" class="p">否</p></td></tr><tr data-tag="tr" id="tr-01u-8ub-pf5" class="tr"><td data-tag="td" id="td-tq4-xqr-7hk" class="td"><p data-tag="p" id="p-nar-dsf-l6s" class="p">设置列约束 NOT NULL</p></td><td data-tag="td" id="td-8vc-biu-o3x" class="td"><p data-tag="p" id="p-50p-kf9-br0" class="p">否</p></td><td data-tag="td" id="td-csr-mb9-oj7" class="td"><p data-tag="p" id="p-9gh-xj1-0dv" class="p">-</p></td><td data-tag="td" id="td-uk0-6zh-uyr" class="td"><p data-tag="p" id="p-e45-vt3-p2k" class="p">-</p></td></tr><tr data-tag="tr" id="tr-wz7-nnm-0rd" class="tr"><td data-tag="td" id="td-vzy-hz6-g22" class="td"><p data-tag="p" id="p-kxx-m4n-fsb" class="p">添加外键约束</p></td><td data-tag="td" id="td-6oa-lme-bfv" class="td"><p data-tag="p" id="p-ijy-wez-f3f" class="p">否</p></td><td data-tag="td" id="td-ilb-xt6-5vl" class="td"><p data-tag="p" id="p-o1a-7qk-z90" class="p">-</p></td><td data-tag="td" id="td-vnc-dla-kt3" class="td"><p data-tag="p" id="p-jni-wlz-rgx" class="p">-</p></td></tr><tr data-tag="tr" id="tr-b9w-qvd-ti9" class="tr"><td data-tag="td" id="td-ycc-2y0-ltr" class="td"><p data-tag="p" id="p-vxv-2lr-g08" class="p">删除外键约束</p></td><td data-tag="td" id="td-kn1-f62-si8" class="td"><p data-tag="p" id="p-ftr-8ui-tlg" class="p">是</p></td><td data-tag="td" id="td-4qw-tvq-1oy" class="td"><p data-tag="p" id="p-4j1-i3k-oxc" class="p">是</p></td><td data-tag="td" id="td-1oz-e1u-4go" class="td"><p data-tag="p" id="p-27g-xgs-qgv" class="p">否</p></td></tr><tr data-tag="tr" id="tr-w8f-2pg-yi3" class="tr"><td data-tag="td" id="td-sg5-omg-ey4" class="td"><p data-tag="p" id="p-9b3-hvy-duc" class="p">修改行格式</p></td><td data-tag="td" id="td-9oc-ing-mb4" class="td"><p data-tag="p" id="p-07h-rc6-qj9" class="p">是</p></td><td data-tag="td" id="td-ykd-c68-7vm" class="td"><p data-tag="p" id="p-1y5-1bt-r2q" class="p">是</p></td><td data-tag="td" id="td-9fn-k7t-zd2" class="td"><p data-tag="p" id="p-jbo-y2h-il0" class="p">是</p></td></tr><tr data-tag="tr" id="tr-iaw-fl5-hz0" class="tr"><td data-tag="td" id="td-wfc-i58-2we" class="td"><p data-tag="p" id="p-77i-35x-uop" class="p">修改 KEY_BLOCK_SIZE</p></td><td data-tag="td" id="td-d2s-gjh-8gm" class="td"><p data-tag="p" id="p-jk2-hz8-f9t" class="p">是</p></td><td data-tag="td" id="td-7k0-ehg-ahq" class="td"><p data-tag="p" id="p-q5l-va5-ldp" class="p">是</p></td><td data-tag="td" id="td-7yf-zdg-dhn" class="td"><p data-tag="p" id="p-3uw-ruj-goa" class="p">是</p></td></tr><tr data-tag="tr" id="tr-ue0-zgr-div" class="tr"><td data-tag="td" id="td-g2y-8cf-r6e" class="td"><p data-tag="p" id="p-8h3-9jt-ldq" class="p">设置字符集</p></td><td data-tag="td" id="td-ru2-kb4-7rx" class="td"><p data-tag="p" id="p-wpp-t7f-kpx" class="p">否</p></td><td data-tag="td" id="td-02q-d8x-j56" class="td"><p data-tag="p" id="p-lnu-u2c-tfx" class="p">-</p></td><td data-tag="td" id="td-m52-p48-36b" class="td"><p data-tag="p" id="p-hlu-msv-h49" class="p">-</p></td></tr><tr data-tag="tr" id="tr-l7s-pub-j5w" class="tr"><td data-tag="td" id="td-pcy-cnm-xj5" class="td"><p data-tag="p" id="p-6is-qpd-e6g" class="p">转换字符集</p></td><td data-tag="td" id="td-20u-kny-6r9" class="td"><p data-tag="p" id="p-fih-bap-45x" class="p">否</p></td><td data-tag="td" id="td-hue-zw2-5u9" class="td"><p data-tag="p" id="p-1t8-a3j-55f" class="p">-</p></td><td data-tag="td" id="td-w1q-kdh-zog" class="td"><p data-tag="p" id="p-gy5-tat-vte" class="p">-</p></td></tr></tbody></table>