|
|
You can enter three kinds of commands or statements interactively at the SQL> prompt:
Creating and Altering Database Objects
In an isql session you can submit DDL statements one by one to CREATE or DROP databases, domains, generators, tables, indexes, triggers, and stored procedures. With the exception of generators, you can also issue ALTER statements for any of these objects.
While it is possible to build a database by submitting and committing a series of DDL statements during an interactive isql session, this approach is ad hoc. It leaves you with no documentation of the process and potential holes in your QA review process.
Scripts
It is very good practice to use a script to create your database and its objects. A script for creating and altering database objects is sometimes known as a schema script, a data definition file, or just a DDL script. The topic of schema scripting is covered in detail in Chapter From Drawing Board to Database.
Scripting ongoing changes in a DDL script gives you a permanent record of the evolution of your database and the ability to review and reverse any imprudent changes. Isql can create a script during an interactive session by passing your keyboard input to a named file. To find out how to do this, read the notes on the OUTPUT command in the next section.
You can run scripts—whether created in isql or by another text editor—using the INPUT command. INPUT can be used inside scripts, too, to build nested scripts.
|
|
Firebird Related Tutorials |
|
---|---|
MySQL Tutorial | Linux Tutorial |
Windows 10 Tutorial | Windows 10 Development Tutorial |
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.