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|
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.