droptb.sql

来自「在Delphi环境下可运行」· SQL 代码 · 共 41 行

/*
    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 ;