Generate schema name on column domains

441 views Asked by At

I have a schema named "Core" and this schema has several domains (Id, Name, ...)

My DBMS is Microsoft SQL Server 2014.

This is the definition for "Name" domain: NameDomain

When I generate Sql the column tables haven't the domain schema: enter image description here

If I run the sql as PowerDesigner generates, I get an error telling me that not found "Id": Msg 2715, Level 16, State 6, Line 18 Column, parameter, or variable #1: Cannot find data type Id

When I manually write the schema before domain its works. This way:

create table Security.Table1 (
    Id                   Core.Id                   not null,
    Nombre               Core.Name                 not null
)

How to do to force generate sql with domains schema name?

0

There are 0 answers