Firebird Question:
Download Job Interview Questions and Answers PDF
How to create a database from my program?
Answer:
Firebird doesn't provide a way to create database using SQL. You need to either use the Services API, or external tool. As API for database creation is often not available in libraries, you can call Firebird's isql tool to do it for you.
Let's first do it manually. Run the isql, and then type:
SQL>CREATE DATABASE 'C:dbasesdatabase.fdb' user 'SYSDBA' password 'masterkey';
That's it. Database is created. Type exit; to leave isql.
To do it from program, you can either feed the text to execute to isql via stdin, or create a small file (ex. create.sql) containing the CREATE DATABASE statement and then invoke isql with -i option:
isql -i create.sql
Let's first do it manually. Run the isql, and then type:
SQL>CREATE DATABASE 'C:dbasesdatabase.fdb' user 'SYSDBA' password 'masterkey';
That's it. Database is created. Type exit; to leave isql.
To do it from program, you can either feed the text to execute to isql via stdin, or create a small file (ex. create.sql) containing the CREATE DATABASE statement and then invoke isql with -i option:
isql -i create.sql
Download Firebird Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How do convert or display the date or time as string? | How to deactivate triggers? |