Table: dbo.Date_Format
Columns
NameTypeConstraintsDescription
date_format_KEYint (4)NOT NULLPrimary key for this table
templatenvarchar (60)NOT NULLTemplate used for formatting a date. Must use .NET DateTime custom date and time format specifiers.
upper_casebit (1)NOT NULLFlag to force day/month names in the resultant formatted date to be displayed in upper case
Primary key
NameColumnsDescription
PK_Date_Formatdate_format_KEY
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Checkbook__Date_Format__date_format_KEYdate_format_KEYCheckbook

Schema diagram