Database Script

[jdavid]

Two questions:
1: When creating the DDL scripts from the database entity, is there a way to create the DDL script for multiple tables at one time, so that tables get created in the correct order with the correct FK constraints.

2: Is the a way to define default values within the database model to attributes.

[hd]

1: When creating the DDL scripts from the database entity, is there a way to create the DDL script for multiple tables at one time, so that tables get created in the correct order with the correct FK constraints.

Foreign keys are added at the end of the script with alter table statements, so create table order is not relevant.

2: Is the a way to define default values within the database model to attributes.

Enter column default in the "Initial" attribute field.

[jdavid]

Thanks for the reply...but it seems the EA will only create a script for one table at a time.....so if you want to select 10 tables and create the ddl script, how would you do this?

[«Midnight»]

Have you tried selecting the package in the Project View tree, and then using the Project / Database Engineering / Generate Package DDL menu?

This should give you a dialog with serveral options as well as a list of the tables in the package, defaulting (I believe) to all selected. You can then select or clear the tables you want.