cloudscape.sql

来自「J2EE导学」· SQL 代码 · 共 12 行

drop table coffee;
drop method alias COUNTCOFFEE;
drop method alias INSERTCOFFEE;

create table coffee (name varchar(32), qty integer);

create method alias COUNTCOFFEE for Procs.countCoffee;
create method alias INSERTCOFFEE for Procs.insertCoffee;

exit;