转载自 oracle中创建表时添加注释
https://www.cnblogs.com/xujiating/p/6236592.html
创建新表MESSAGES
CREATE TABLE MESSAGES(
MESSAGE_ID NUMBER(6) PRIMARY KEY,
SEND_USER VARCHAR2(200),
RECEIVE_USER VARCHAR2(200),
SEND_DATE DATE
)
添加表注释:
COMMENT ON TABLE MESSAGES IS ‘消息’;
添加字段注释:
COMMENT ON COLUMN MESSAGES.MESSAGE_ID IS ‘消息ID’;
COMMENT ON COLUMN MESSAGES.SEND_USER IS ‘发送者用户信息’;
COMMENT ON COLUMN MESSAGES.RECEIVE_USER IS ‘接收者用户信息’;
COMMENT ON COLUMN MESSAGES.SEND_DATE IS ‘发送时间’;