Čeština
English
Online Data Modeler
Create and manage your database model in WEB interface!
Database specific support
Pá, 04/24/2009 - 14:21 — admin
This page contains information about support of specific database features under all supported engines.
Feature support
| Oracle | Micosoft SQL | MySQL | Postgre SQL | MS Access | SQLite | EffiProz | |
| Tables | yes | yes | yes | yes | yes | yes | yes |
| - Primary keys | yes | yes | yes (5.0) | yes | yes | yes | yes |
| - Foreign keys | yes | yes | yes (5.0) | yes | yes | yes | yes |
| - Check constraints | yes | yes | n/a | no | n/a | n/a | yes |
| - Unique constraints | yes | yes | yes (5.0) | no | no | no | yes |
| - Indexes | yes | yes | yes (5.0) | no | yes | yes | yes |
| Triggers | yes | yes | yes (5.0) | no | no | yes | yes |
| Views | yes | yes | yes (5.0) | no | no | yes | yes |
| Stored procedures | yes | yes | yes (5.0) | no | no | no | yes |
| Functions | yes | yes | yes (5.0) | no | no | no | yes |
| Events | n/a | n/a | yes (5.1) | n/a | n/a | n/a | n/a |
| Assemblies | n/a | no | n/a | n/a | n/a | no | n/a |
| Domains (type aliases) | no | yes | n/a | no | n/a | n/a | yes |
Version support
| MySQL | 4.1, 5.0, 5.1, 5.4, 5.5 | |
| Microsoft SQL Server | 2000, 2005, 2008 | |
| SQLite | Version 2 (only open existing), 3 | |
| MS Access | 2000, 2007 | |
| Postgre SQL | 8.x | |
| EffiProz | 1.4 | |
| Oracle | 9g, 10g, 11g |
