Database Schema Designer v1.2 Capabilities
Database Schema Designer, like all things in life, has it's limitations. Some of the limits are inherited from SQL Server and others came about through the development process. We believe a delicate balance has been struck between performance and usability. Most users should never have any issue with these limits.
| Check Constraints | 250 | |
|
Comments
- Title Length ( Characters )
- Comment Length ( Characters )
|
600
1024 1024 |
|
| Foreign Keys ( per Table ) | 50 | |
| Functions | 300 | |
|
Indexes ( per Table )
- Clustered Indexes ( per Table )
- Non-Clustered Indexes ( per Table )
* Remember that Primary Keys and Unique Constraints are Indexes at root.
|
51
1 50 |
|
| Naming Convention Items | 100 | |
| Object Description Length ( Characters ) | 1024 | |
|
Permissions
- Functions
- Stored Procedures
- Tables
- Views
|
200
50 50 50 50 |
|
| Rules | 300 | |
| Stored Procedures | 300 | |
| SQL Script Length ( Characters ) | 64,000 | |
|
Tables
- Columns
- Primary Key Columns
- Clustered Indexes
- Non-Clustered Indexes
- Foreign Keys
|
300
150 16 1 50 50 |
|
| Triggers | 300 | |
| User Defined Datatypes | 300 | |
|
Unique Constraints ( per Table )
- Clustered ( per Table )
- Non-Clustered ( per Table )
* Remember that Unique Constraints are Indexes at root.
|
51
1 50 |
|
|
Views
- Columns
- From Objects
|
300
150 150 |
|