> salam semua ...
>
> butuh pencerahan dong, saya pake Interbase, masalah saya sbb:
> dalam table PART ada column PART_NAME varchar(30), kemudian saya mau
> ganti ke PART_NAME varchar(150). masalahnya, table part sudah berisi
> data lumayan banyak.
>
'menggemukkan' lebih mudah dari pada 'mengkuruskan' kolom ( tdk ada resiko
perubahan isi data).
2 langkah :
CREATE DOMAIN NEW_DOMAIN AS
VARCHAR(150) CHARACTER SET ASCII
COLLATE ASCII
update RDB$RELATION_FIELDS
set RDB$FIELD_SOURCE = 'NEW_DOMAIN'
where (RDB$FIELD_NAME = 'PART_NAME') and
(RDB$RELATION_NAME = 'PART')
ps. DDL command tsb spesifik ke interbase/firebird aja.
salam,
jp
--
Berlangganan: [EMAIL PROTECTED]
Stop Berlangganan: [EMAIL PROTECTED]
Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED]
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/Delphindo/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
