quote:

---

I could give an example, if need be.

---

use <Database, sysname, MyDatabase>
go

if  exists (
    select *
    from
        sys.objects
    where
        object_id = object_id(N'Student.Fact<TableName, sysname, SampleTable>') and
        type in (N'U'))
    drop table Student.Fact<TableName, sysname, SampleTable>
go


create table Student.Fact<TableName, sysname, SampleTable> (
    <TableName, sysname, SampleTable>ID int identity (1,1) not null,
    SourceKey int not null,
    DimensionID int not null,
    EventID int not null
        constraint df_Fact<TableName, sysname, SampleTable>_EventID default (0),
    constraint pk_Fact<TableName, sysname, SampleTable> primary key clustered (<TableName, sysname, SampleTable>ID),
    constraint uq_Fact<TableName, sysname, SampleTable>_SourceKey unique nonclustered (SourceKey),
    constraint fk_Fact<TableName, sysname, SampleTable>_Dimension foreign key (DimensionID) references Student.Dimension
)
go

exec HEA.UpdateDictionary @Value = 'Table for the <TableName, sysname, SampleTable> fact.  This table is loaded by HEA.LoadFact<TableName, sysname, SampleTable>.', @Level0Object = 'Student', @Level1Object = 'Fact<TableName, sysname, SampleTable>'
go
/******<DELETE ME>*******/
select
    'exec HEA.UpdateDictionary @Value = ''' +
        case
            when vd.Value is not null then replace(convert(varchar(8000), vd.Value),'''', '''''')
            when sc.name = '<TableName, sysname, SampleTable>ID' and dp.Name = 'MS_Description' then 'Surrogate key from My Database'
            else ''
        end + ''', @Level2Object = ''' + sc.name + ''', @Name = ''' + dp.Name +
    ''',  @Level0Object = ''Student'', @Level1Object = ''Fact<TableName, sysname, SampleTable>'''
from
    HEA.DictionaryProperty dp
    inner join (
        sys.columns sc
        inner join sys.objects so
            on sc.object_id = so.object_id
        inner join sys.schemas ss
            on so.schema_id = ss.schema_id
        left join HEA.ViewDictionary vd
            on vd.Level0Name = 'Stage' and
               vd.Level1Name = 'Fact<TableName, sysname, SampleTable>' and
               vd.Level2Name = sc.Name)
        on (vd.Name is not null and
            vd.Name = dp.Name) or
           (vd.Name is null)
where
    so.name = 'Fact<TableName, sysname, SampleTable>' and
    ss.name = 'Student' and
    not (sc.Name = '<TableName, sysname, SampleTable>ID' and
         dp.Name = 'Source')
order by
    dp.Name desc,
    sc.Column_id
/*****</DELETE ME>*******/
go
exec HEA.UpdateDictionary @Name = 'MS_Description', @Value = 'Default constriant on Student.Fact<TableName, sysname, SampleTable>(EventID) = 0', @Level0Object = 'Student', @Level1Object = 'Fact<TableName, sysname, SampleTable>', @Level2Object = 'df_Fact<TableName, sysname, SampleTable>_EventID'
exec HEA.UpdateDictionary @Name = 'MS_Description', @Value = 'Clustered Primary Key on Student.Fact<TableName, sysname, SampleTable>(<TableName, sysname, SampleTable>ID)', @Level0Object = 'Student', @Level1Object = 'Fact<TableName, sysname, SampleTable>', @Level2Object = 'pk_Fact<TableName, sysname, SampleTable>'
exec HEA.UpdateDictionary @Name = 'MS_Description', @Value = 'Nonclustered unique constraint on Student.Fact<TableName, sysname, SampleTable>(SourceKey)', @Level0Object = 'Student', @Level1Object = 'Fact<TableName, sysname, SampleTable>', @Level2Object = 'uq_Fact<TableName, sysname, SampleTable>_SourceKey', @SyncDictionary = 1
go