SQLSERVER SQL语句 给列加注释

算是mark一下，第一次通过语句给列加注释。

--建表
create table "SHMC"."BH_ASSESS_KPI_WORK_ORDER"(
    "ID" BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (
        START WITH 1,
        INCREMENT BY 1,
        CACHE 20,
        NO MINVALUE,
        NO MAXVALUE,
        NO CYCLE,
        NO ORDER
),
"work_order_num" varchar(20),
"trandate" varchar(10),
"branch_name" varchar(100),
"order_status" varchar(10),
"current_status" varchar(10),
"submit_time" varchar(20),
"submit_person" varchar(10),
"operate_name" varchar(10)
) in "TAPP_16K";
--加注释
COMMENT ON "SHMC"."BH_ASSESS_KPI_WORK_ORDER" (
  "ID"    IS  '自然主键',                   
  "work_order_num"    IS  '工单编号' ,
    "trandate" IS '日期',
    "branch_name" IS '分公司',
    "order_status" IS '工单状态',
    "current_status" IS '当前状态',
    "submit_time" IS '提交时间',
    "submit_person" IS '提交人',
    "operate_name" IS '操作'
);