Application 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
* Demo version may have further limitations