Languages

Home

Database specific support

  Micosoft SQL MySQL Postgre SQL MS Access SQLite
Tables yes yes yes yes yes
- Primary keys yes yes (5.0) yes yes yes
- Foreign keys yes yes (5.0) yes yes yes *1
- Check constraints yes n/a no n/a n/a
- Unique constraints yes yes (5.0) no no no
- Indexes yes yes (5.0) no yes yes
Triggers yes yes (5.0) no no yes
Views yes yes (5.0) no no yes
Stored procedures yes yes (5.0) no no no
Functions yes yes (5.0) no no no
Events n/a yes (5.1) n/a n/a no
Assemblies no n/a n/a n/a no
Domains (type aliases) yes n/a no n/a n/a
  • *1 - SQLite doesn't support foreign keys, but it parses them and offer it in system catalog. So DatAdmin works with foreign keys as in other db engines, also master/detail views using them are possible.

Version support

MySQL 4.0, 5.0  
Microsoft SQL Server 2000, 2005, 2008  
SQLite Version 2 (only open existing), 3  
MS Access 2000, 2007  
Postgre SQL 8.x