Previous Topic: MS_SQL_TBL_RES_SEG (MS SQL table reside on segment)Next Topic: MS_SQL_TD_IDX_RES (MS SQL Technical Design index reside on segment)


MS_SQL_TD (Technical Design MS SQL Server Extension)

Column Name

Coltype

Description

MODEL_ID

NUMERIC

ID of the containing model

TBNAME

STRING

MS_SQL_TD

ID

NUMERIC

Unique identifier

ORG_ENCY_ID

NUMERIC

Original encyclopedia identifier

ORG_ID

NUMERIC

Original object identifier

OWNER_ID

STRING

Owner identifier

DFLT_DBNAME

STRING

Default DB Name

RI_ENFRCMNT

CHAR

Referential integrity enforcement

RES_WORD_CHK

CHAR

Reserved word check?

DBMS_REL_VER

CHAR

DBMS release version

PV_READ_ENF

CHAR

Permitted value READ enforcement

PV_DBMS_ENF

CHAR

Permitted value DBMS enforcement

DEF_VALUE_ENF

CHAR

Default value enforced?

NULL_OR_DEF

CHAR

Create NULL or default value?

DFLT_DATAFILE

CHAR

Use default datafile?

DFLT_DFILE_SZE

NUMERIC

Default datafile size

FILL_FACTOR

NUMERIC

Fill factor for index

TBL_RESIDE_SEG

STRING

Table reside on segment

IDX_RESIDE_SEG

STRING

Index reside on segment

TECH_DSN_ID

NUMERIC

Base technical design this object is extended from.

Join with TECHNICAL_DESIGN.