📄 droptb.sql
字号:
/*
THIS FILE IS FOR USE WITH THE TUTORIAL IN "GETTING STARTED",
IT IS NOT MEANT TO BE USED WITHOUT REFERRING TO THE MANUAL.
* You must change the parameters below to match your
* server name, database name , username, and password.
* This file defines tables for the STUDENT database.
*/
CONNECT "D:\InterBaseDB\STUDENT.GDB"
USER "SYSDBA" PASSWORD "masterkey";
SET TERM ^ ;
/*
** 基本信息表BaseTB
*/
drop index idx_BaseTB ^
drop table BaseTB ^
/*
** 学员课时CourseTB
*/
drop table CourseTB ^
/*
** 学员成绩表CreditTB
*/
drop table CreditTB ^
/*
** 系统参数表SysPramTB
*/
drop table SysPramTB ^
SET TERM ; ^
COMMIT ;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -