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