From the command line, you can use the –extract option to output the DDL statements that define the metadata for a database.
All reserved words and objects are extracted into the file in uppercase unless the local language uses a character set that has no uppercase. The output script is created with commit following each set of commands, so that tables can be referenced in subsequent definitions. The output file includes the name of the object and the owner, if one is defined.
The optional –output flag reroutes output to a named file.
Use this syntax:isql [[-extract | -x][-a] [[-output | -o] outputfile]] database
The –x option can be used as an abbreviation for –extract. The –a flag directs isql to extract all database objects. Note that the output file specification, outputfile , must be a fully qualified path and follow the –output flag. The path and name of the database being extracted can be at the end of the command.
You can use the resulting text file to
Using isql –extract
The following statement extracts the SQL schema from the database employee.fdb to a schema script file called employee.sql:isql -extract -output /data/scripts/employee.sql /data/employee.fdb
This command is equivalent:isql -x -output /data/scripts/employee.sql /data/employee.fdb
These objects and items are not extracted:
Using isql –a
The –(e)x(tract) option extracts metadata for SQL objects only. If you wish to extract a schema script that includes declarations, such as DECLARE EXTERNAL FUNCTION and DECLARE FILTER, use the –a option.
For example, to extract DDL statements from database employee.fdb and store in the file employee.sql, enterisql -a -output /data/scripts/employee.sql /data/employee.fdb
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.