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:
When I generate Sql the column tables haven't the domain schema:
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?