CUBRID의 도메인 변경방법은 아래와 같습니다.
순서에 맞게 해당 환경의 애트리뷰트(컬럼), 테이블 명을 적용하시기 바랍니다.
=== Help: Schema of a Class> ===
<Class Name>
dumy
<Attributes>
...
exam : character varying(300)
csql> alter table dumy rename exam as temp
csql> ;x
Current transaction has been committed.
1 command(s) successfully processed.
csql> alter table dumy add attribute exam string
csql> ;x
Current transaction has been committed.
1 command(s) successfully processed.
csql> update dumy set exam=cast(temp as string)
csql> ;x
23 rows updated.
Current transaction has been committed.
1 command(s) successfully processed.
csql> alter table dumy drop attribute temp
csql> ;x
Current transaction has been committed.
1 command(s) successfully processed.
csql> ;sc dumy
=== Help: Schema of a Class> ===
<Class Name>
dumy
<Attributes>
...
exam : string
Current transaction has been committed.
순서에 맞게 해당 환경의 애트리뷰트(컬럼), 테이블 명을 적용하시기 바랍니다.
=== Help: Schema of a Class> ===
<Class Name>
dumy
<Attributes>
...
exam : character varying(300)
csql> alter table dumy rename exam as temp
csql> ;x
Current transaction has been committed.
1 command(s) successfully processed.
csql> alter table dumy add attribute exam string
csql> ;x
Current transaction has been committed.
1 command(s) successfully processed.
csql> update dumy set exam=cast(temp as string)
csql> ;x
23 rows updated.
Current transaction has been committed.
1 command(s) successfully processed.
csql> alter table dumy drop attribute temp
csql> ;x
Current transaction has been committed.
1 command(s) successfully processed.
csql> ;sc dumy
=== Help: Schema of a Class> ===
<Class Name>
dumy
<Attributes>
...
exam : string
Current transaction has been committed.