질의작성

데이터 필드의 타입 변경하기

by admin posted Nov 21, 2008
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.

Articles

5 6 7 8 9 10 11 12 13 14