delete

■deleteコマンド
レコードを消去

delete from TEST_T#すべての内容を消去。設定は残る。
delete from TEST_T where ID_C=3 and NAME_C='TAKEUCHI';
delete from TEST_T where ADD_C='Osaka';

フィールドを消去

alter table TEST_T drop AGE_C01;

テーブルを消す

drop table TEST_T;
drop table if exists TEST_T,HOKA_T;エラーを出さずに複数削除
drop database ADDRESS_D;