| Object | Code | Notation | Length | Plural | Prefix | Suffix | Abbreviation | Char Mask | Example |
|---|---|---|---|---|---|---|---|---|---|
| Database | UPPERCASE | 30 | No | No | No | Yes | [A-z] | MYDATABASE | |
| Database Trigger | PascalCase | 50 | No | DTR_ | No | Yes | [A-z] | DTR_CheckLogin | |
| Schema | lowercase | 30 | No | No | No | Yes | [A-z][0-9] | myschema | |
| File Table | PascalCase | 128 | No | FT_ | No | Yes | [A-z][0-9] | FT_MyTable | |
| Global Temporary Table | PascalCase | 118 | No | No | No | Yes | ##[A-z][0-9] | ##MyTable | |
| Local Temporary Table | PascalCase | 118 | No | No | No | Yes | #[A-z][0-9] | #MyTable | |
| Table | U | PascalCase | 30 | No | No | No | Yes | [A-z][0-9] | MyTable |
| Table Column | PascalCase | 30 | No | No | No | Yes | [A-z][0-9] | MyColumn | |
| Table Default Values | D | PascalCase | 128 | No | DF_ | No | Yes | [A-z][0-9] | DF_MyTable_MyColumn |
| Table Check Column Constraint | C | PascalCase | 128 | No | CK_ | No | Yes | [A-z][0-9] | CK_MyTable_MyColumn |
| Table Check Table Constraint | C | PascalCase | 128 | No | CTK_ | No | Yes | [A-z][0-9] | CTK_MyTable_MyColumn_AnotherColumn |
| Table Primary Key | PK | PascalCase | 128 | No | PK_ | No | Yes | [A-z][0-9] | PK_MyTableID |
| Table Alternative Key | UQ | PascalCase | 128 | No | AK_ | No | Yes | [A-z][0-9] | AK_MyTable_MyColumn_AnotherColumn |
| Table Foreign Key | F | PascalCase | 128 | No | FK_ | No | Yes | [A-z][0-9] | FK_MyTable_ForeignTableID |
| Table Clustered Index | PascalCase | 128 | No | IXC_ | No | Yes | [A-z][0-9] | IXC_MyTable_MyColumn_AnotherColumn | |
| Table Non Clustered Index | PascalCase | 128 | No | IX_ | No | Yes | [A-z][0-9] | IX_MyTable_MyColumn_AnotherColumn | |
| Table Trigger | TR | PascalCase | 128 | No | TR_ | No | Yes | [A-z][0-9] | TR_MyTable_LogicalName |
| View | V | PascalCase | 128 | No | VI_ | No | No | [A-z][0-9] | VI_LogicalName |
| Stored Procedure | P | PascalCase | 128 | No | usp_ | No | No | [A-z][0-9] | usp_LogicalName |
| Scalar User-Defined Function | FN | PascalCase | 50 | No | udf_ | No | No | [A-z][0-9] | udf_FunctionLogicalName |
| Table-Valued Function | FN | PascalCase | 50 | No | tvf_ | No | No | [A-z][0-9] | tvf_FunctionLogicalName |
| Synonim | SN | camelCase | 128 | No | sy_ | No | No | [A-z][0-9] | sy_logicalName |
| Sequence | SO | PascalCase | 128 | No | sq_ | No | No | [A-z][0-9] | sq_TableName |
| CLR Assembley | PascalCase | 128 | No | CA | No | Yes | [A-z][0-9] | CALogicalName | |
| CLR Stored Procedures | PC | PascalCase | 128 | No | pc_ | No | Yes | [A-z][0-9] | pc_CAName_LogicalName |
| CLR Scalar User-Defined Function | PascalCase | 50 | No | cudf_ | No | No | [A-z][0-9] | cudf_CAName_LogicalName | |
| CLR Table-Valued Function | PascalCase | 50 | No | ctvf_ | No | No | [A-z][0-9] | ctvf_CAName_LogicalName | |
| CLR User-Defined Aggregates | PascalCase | 50 | No | ca_ | No | No | [A-z][0-9] | ca_CAName_LogicalName | |
| CLR User-Defined Types | PascalCase | 50 | No | ct_ | No | No | [A-z][0-9] | ct_CAName_LogicalName | |
| CLR Triggers | PascalCase | 50 | No | ctr_ | No | No | [A-z][0-9] | ctr_CAName_LogicalName |