Firebird ISQL Tool

MICS
connect 'C:\MICS\Delphi2010\STD\MICSV195.FDB' user 'sysdba' password '《パスワード》' ;

RESOURCE
connect 'C:\opengion\dbs\firebird\resourcedb.fdb' user 'GE' password 'GE';


show table;

show table GEA08;


ALTER TABLE GEA08 ALTER COLUMN DESCRIPTION TO DESCRIPTION_XX;
ALTER TABLE GEA08 ADD DESCRIPTION VARCHAR(4000) ;
update GEA08 set DESCRIPTION = cast(DESCRIPTION_XX as char) ;

ALTER TABLE GEA08 DROP DESCRIPTION_XX ;


select NAME_JA from GEA08 where LANG='ja' and CLM='GEA08' ;


ALTER TABLE GE20 ALTER COLUMN PARAM TO PARAM_XX;
ALTER TABLE GE20 ADD PARAM VARCHAR(4000) ;
update GE20 set PARAM = cast(PARAM_XX as char) ;

ALTER TABLE GE20 DROP PARAM_XX ;



最初の 10行を取得
SELECT FIRST 10 * FROM GEA08;

