CREATE TABLE 表名 (...) COMMENT 'order_key=column_name[,column_name]';## 举例:CREATE TABLE part (p_partkey BIGINT NOT NULL PRIMARY KEY,p_name VARCHAR(55) NOT NULL,p_mfgr CHAR(25) NOT NULL,p_brand CHAR(10) NOT NULL,p_type VARCHAR(25) NOT NULL,p_size BIGINT NOT NULL,p_container CHAR(10) NOT NULL,p_retailprice DECIMAL(15,2) NOT NULL,p_comment VARCHAR(23) NOT NULL) COMMENT '零件的信息表 order_key=p_brand,p_container,p_type';
ALTER TABLE table_name COMMENT 'order_key=column_name[,column_name]';## 举例:ALTER TABLE part COMMENT '零件信息表 order_key=p_brand,p_container,p_type';
ALTER TABLE part COMMENT '零件的信息表 order_key=p_partkey,p_type,p_partkey COLUMNAR=1';
ALTER TABLE part COMMENT '零件的信息表 order_key=column';
ALTER TABLE part COMMENT '零件的信息表 ORDERKEY=column';
ALTER TABLE part COMMENT '零件的信息表order_key=p_partkey';
ALTER TABLE part COMMENT '零件的信息表 order_key=p_partkey order_key=p_partkey';
ALTER TABLE part COMMENT '零件的信息表 order_key= COLUMNAR=1';
Was this page helpful?
You can also Contact sales or Submit a Ticket for help.
Help us improve! Rate your documentation experience in 5 mins.
Feedback