sql问题--comment
CREATETABLEDEV.GL_BS_IS_ACCOUNT(LINE_NUMNUMBER(15),LEVEL4_DESCVARCHAR2(150),LEVEL4_CO...
CREATE TABLE DEV.GL_BS_IS_ACCOUNT
(
LINE_NUM NUMBER (15),
LEVEL4_DESC VARCHAR2 (150),
LEVEL4_CODE VARCHAR2 (150),
KR_DESC VARCHAR2 (150),
FLAG VARCHAR2 (10),
CREATION_DATE DATE,
CREATED_BY NUMBER
)
TABLESPACE STXD
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE
(
INITIAL 1048576
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
DISABLE ROW MOVEMENT ;
COMMENT ON TABLE DEV.GL_BS_IS_ACCOUNT IS 'BS/IS Account Sort Temp Table' ;
最后一句:
COMMENT ON TABLE DEV.GL_BS_IS_ACCOUNT IS 'BS/IS Account Sort Temp Table' ;
作用是什么?
麻烦给详细讲讲。谢谢
还是不明白具体有什么作用? 展开
(
LINE_NUM NUMBER (15),
LEVEL4_DESC VARCHAR2 (150),
LEVEL4_CODE VARCHAR2 (150),
KR_DESC VARCHAR2 (150),
FLAG VARCHAR2 (10),
CREATION_DATE DATE,
CREATED_BY NUMBER
)
TABLESPACE STXD
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE
(
INITIAL 1048576
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
DISABLE ROW MOVEMENT ;
COMMENT ON TABLE DEV.GL_BS_IS_ACCOUNT IS 'BS/IS Account Sort Temp Table' ;
最后一句:
COMMENT ON TABLE DEV.GL_BS_IS_ACCOUNT IS 'BS/IS Account Sort Temp Table' ;
作用是什么?
麻烦给详细讲讲。谢谢
还是不明白具体有什么作用? 展开
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询