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.
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 Interview Questions
|RDBMS Interview Questions||MySQL Interview Questions|
|Linux Interview Questions||Mac OS X Deployment Interview Questions|
|Windows Administration Interview Questions||Windows Server 2003 Interview Questions|
|SQL Interview Questions||NoSQL Interview Questions|
|Advanced C++ Interview Questions|
Introduction To Client/server Architecture
About Firebird Data Types
Date And Time Types
Blobs And Arrays
From Drawing Board To Database
Creating And Maintaining A Database
Firebird’s Sql Language
Expressions And Predicates
Querying Multiple Tables
Ordered And Aggregated Sets
Overview Of Firebird Transactions In
Programming With Transactions
Introduction To Firebird Programming
Developing Psql Modules
Error Handling And Events
Security In The Operating Environment
Configuration And Special Features
Interactive Sql Utility (isql)
Database Backup And Restore (gbak)
Housekeeping Tool (gfix)
Understanding The Lock Manager
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.