Microsoft SQL Server 2012 (2008) прозволяет создавать табличные типы, мы их используем в качестве рараметров для процедур.
CREATE TYPE dbo.ListOfInt AS TABLE(val int NULL);
ERwin это не поддерживает и поддерживать не будет: "As you may already know that in ERwin Datatypes are also linked with Domains by virtue of columns. There is a one-to-one co-relation between a Domain and a datatype. Creating Type as a table will essentially warrant one Domain to be associated with multiple datatypes.
This is a massive change and even though this may be looked at in the future there are no plans for this in the immediate future..."

А как с этим у PowerDesigner и Embarcadero E/R Studio?

Embarcadero's Technical Support написал, что в данный момент не поддерживает, но в планах есть enhancement - "Support for user defined table type in MS SQL Server"

PowerDesigner тоже ответил: editing the XDB (Database Definition File).
Here are the steps, having your SQL 2012 model open:
* Open menu "Database > Edit Current DBMS...."
* On left pane, navigate to Script\Objects\Abstract Data Type\Create
You can see the definition:
<<
create type [%QUALIFIER%]%ADT%[%TYPE%=CLR?
external name [%Assembly.GeneratedName%[.%Class%]]:
as table (
%ADTDEF%
)]
>>
You need to replace it with
<<
create type [%QUALIFIER%]%ADT%[%TYPE%=CLR?
external name [%Assembly.GeneratedName%[.%Class%]]:[%TYPE%=Table?
as table (
%ADTDEF%
)]]
>>
* Hit OK and try reverse again.

пошёл пробовать

всё равно не работает reverse ingineering:
if exists(select 1 from systypes where name='DDD')
drop type dbo.DDD
go

/*==============================================================*/
/* Domain: DDD */
/*==============================================================*/
create type dbo.DDD
from char(10) not null
go
if exists(select 1 from systypes where name='ListOfInt')
drop type dbo.ListOfInt
go

/*==============================================================*/
/* Domain: ListOfInt */
/*==============================================================*/
create type dbo.ListOfInt
from char(10) not null
go

Infernal V. RavenПример генерации:



а как создать это средствами PowerDesigner ?

спасибо заработало