Skip to Main Content
Forums

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Schema name is missing in DDL

user8249631Sep 12 2014 — edited Sep 15 2014

I am using Oracle SQL Developer Data Modeler Version 4.0.2.840, RDBMS type is SQL Server 2008

schema names are not included in the CREATE TABLE or ALTER TABLE.

I was suggested to add the schema name in a Physical Model and then generate.

I added the schema in both, relational and physical models, but still no schema name.

See the screenshot. Anybody knows how to fix this issue? Thank you

schema.jpg
This post has been answered by Philip Stoyanov-Oracle on Sep 15 2014
Jump to Answer

Comments

Answer

Hi,

you need to check "Include schema in DDL" setting in "Tools>Preferences>Data Modeler>DDL"

Philip

Marked as Answer by user8249631 · Sep 27 2020
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 13 2014
Added on Sep 12 2014
#schema
1 comment
1,500 views