Drop Database

테이블_컬럼_코멘트붙이기.SQL

한알두알 2007. 9. 18. 14:37

SELECT 'COMMENT on TABLE EP_USER.' || TB_NAME || ' IS ''' || MAX(ENTITY_NAME) || ''';' FROM TABLE_COLUMN_LIST GROUP BY TB_NAME

SELECT 'COMMENT on COLUMN EP_USER.' || TB_NAME || '.' || COL_NAME || ' IS ' || '''' || ATRIBUTE_NAME || ''';' FROM TABLE_COLUMN_LIST