Subject Re: [firebird-support] lookin' for big exemple.
Author Helen Borrie
At 02:56 PM 25/02/2004 +0000, you wrote:
>The newbie strikes back !
>
>Hi,
>
>I know christmas is over, i'm looking for a complete exemple of
>script to create a database.

The DDL script for the employee database should be in your /examples directory. If it's not, you can build your own with a tool such as IB_SQL's metadata Extract utility. It will generate a complete script. You can also do it using isql:
From the command line (at your Firebird bin directory):
Windows:
isql -x -a -output d:\scripts\employee.sql c:\progra~01\firebird\firebird_1_5\examples\employee.fdb

Linux:
./isql -x -a -output /mydata/scripts/employee.sql opt/firebird/examples/employee.fdb

Wait for it to finish and then open it in a text editor. Go right to the end, press Return, then re-save it.

/heLen