DB2某建表语句
DB2建表加注解的建表语句
CREATE
TABLE table_name
(
company CHARACTER(1) NOT NULL DEFAULT 'N',
online CHARACTER(1) NOT NULL DEFAULT 'N',
create_time TIMESTAMP DEFAULT CURRENT TIMESTAMP NOT NULL,
PRIMARY KEY(company)
);
COMMENT ON TABLE table_name IS '某某表';
COMMENT ON COLUMN table_name.company IS '分公司码';