Table: dbo.Table_Information
Columns
NameTypeConstraintsDescription
table_information_KEYint (4)NOT NULLDatabase assigned primary key for this table.
namenvarchar (256)NOT NULLName of the table.
default_aliasnvarchar (256)NOT NULLThe default alias to use for this table.
system_tablebit (1)NOT NULLIs the data in this table read-only?
standard_getbit (1)NOT NULLGenerate a standard get procedure for this table?
standard_deletebit (1)NOT NULLGenerate a standard delete procedure for this table?
standard_insertbit (1)NOT NULLGenerate a standard insert procedure for this table?
standard_updatebit (1)NOT NULLGenerate a standard update procedure for this table?
has_listbit (1)NOT NULLDoes this table support a list?
allow_retrieve_allbit (1)NOT NULLIs it allowable to get all the records from this table at once?
table_depthint (4)NOT NULLHow deep in the relationships is this table?
has_entitybit (1)NOT NULLGenerate an entity for this table?
is_groupingbit (1)NOT NULLA grouping has an unique ID and a Description
is_descriptionbit (1)NOT NULLA description has an unique Description.
Primary key
NameColumnsDescription
PK_Table_Informationtable_information_KEY
Unique constraints
NameColumnsDescription
UK_Table_Information$default_aliasdefault_alias
UK_Table_Information$namename

Schema diagram