Languages

Database management

  • Creating and editing tables (CREATE, ALTER TABLE), database specific table properties (MySQL engine, collation)
  • Comfortable foreign key management, UPDATE/DELETE rules
  • CHECK, UNIQUE constraints, indexes
  • Database object management - triggers, functions, stored procedures, views, schemata
  • Generating SQL scripts for different object types - CREATE, DROP
  • MySQL objects: triggers, functions, stored procedures, views, events
  • MS SQL objects: triggers, functions, stored procedures, views
  • SQLite objects: triggers, views
  • Table of supported database objects for each database platform

Basic window, objects of MySQL database, generating SQL scripts for table

Altering table. In References column there is a possibility to select table, which is referenced over foreign key.