Book a Demo

Author Topic: Data Model : View object has no TABLESPACE/OWNER  (Read 3428 times)

Emilio

  • EA User
  • **
  • Posts: 78
  • Karma: +0/-0
    • View Profile
Data Model : View object has no TABLESPACE/OWNER
« on: May 28, 2009, 07:05:56 pm »
There is a lack of consistency in the Data Modelling diagram editor (database models).  When one drops a TABLE object onto the diagram one can go to the Details tab and set the TABLESPACE attribute.

TABLESPACE is however an Oracle thing, if the current setting for database is  SQL Server it should show the label as "SCHEMA".

Also, there is a tagged value named OWNER which is not available in the details tab when it actually should and in particular if one works with SQL Server.

Another reason to expose the OWNER tag in the properties window (Details tab) is that in the Feature Visibility one can specify "Show Owner" which is pretty handy when working with multi-schema data models in which you can immediately see in the diagram the table owner, i.e. dbo.MyTable or  hr.Employees, etc.

Last but not least another inconsistency is that when you drop a VIEW objet onto the model the properties dialog does not allow you to set the OWNER or TABLESPACE. Even when you set these two tagged values using the tag window (extra  work for overloaded designers) the diagram does not show the View Owner as the other database objects do.