您如何在SPARX Enterprise Architect的程序包级别设置数据库模式? [英] How do you set the database schema, at the package level, in SPARX Enterprise Architect?

问题描述

示例:

我有一个数据模型，其中包含一个称为Academic的软件包.在学院内部，我有一张名为讲师和学生"的表格.当我生成DDL"时，我希望将教师和学生生成为:

I have a Data Model with a package called Academic. Inside of Academic, I have tables called Instructor and Student. When I "Generate DDL", I'd like Instructor and Student to be generated as:

CREATE TABLE [Academic].[Instructor] ...
CREATE TABLE [Academic].[Student] ...

我尝试在每个表(有效)上设置名为OWNER(EAUML :: table :: OWNER)的标记值，但是我想我可以以某种方式在包级别进行设置，并具有所有表中的继承"此值.为此，我尝试将新的标记值添加到程序包中，分别为EAUML :: table :: OWNER和OWNER，但无法按预期运行.

I have tried setting the tagged value named OWNER (EAUML::table::OWNER) on each table (which works), however I'd like to think that I could somehow set this at the package level and have all of the tables within 'inherit' this value. To that end, I tried adding a new tagged value to the package, both as EAUML::table::OWNER and OWNER but it doesn't work as desired.

理想情况下，我想使用包名称作为架构名称，但是可以接受的是，架构名称可以是一个单独的值，只要它只在一个地方设置即可.

Ideally I'd like to use the package name as the schema name but it would be acceptable for the schema name to be an individual value, as long as it's only set in one place.

推荐答案

在生成模式时不使用程序包上的设置，因此无济于事.

Settings on the package aren't used when generating the schema, so that won't help.

但是，如果您在程序包浏览器中右键单击该程序包，然后选择代码工程-重置DBMS选项"，则可以更改该程序包中所有表的DBMS类型和表所有者.

But if you right-click the package in the package browser and select Code Engineering -- Reset DBMS Options, you can change the DBMS type and table owner for all tables in the package.

这篇关于您如何在SPARX Enterprise Architect的程序包级别设置数据库模式?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！