Database Schema in DDL generation

[BlueProdigy]

Test driving EA right now and was fiddling with the Database Model and DDL generation.

Where on the table object does the user put the database schema so that when you generate the SQL script, it adds the schema to the code properly?

Example:  [schema].[TableName]

it's defaulting to dbo and we do not use the dbo schema for our web app tables.

[juhi]

Yes, You have to give the value for the OWNER tag for each table. So that EA can pick that value while generating DDL (Please check Generate Table Owner Option in generate DDL Dialog).

HTH

[BlueProdigy]

herm.  thought I did that.  thanks!