DEV Community

Devart Software
Devart Software

Posted on

dbForge Studio First Supported MySQL CHECK Constraints

Devart has rolled out the new release of dbForge Studio for MySQL – a universal GUI tool which, among others, now helps applying integrity constraints to user databases.

CHECK Constraints

Following the significant update of MySQL server, Devart, a recognized vendor of professional database management software, has promptly released a new version of dbForge Studio for MySQL, v8.2. The new version provides full support for the CHECKED constraints. This release has made Devart the first company that provided its users with the latest MySQL feature.

A CHECK constraint is a type of integrity constraints in SQL which allows users to specify a condition on each row in a table. It is used to limit the value range that can be placed in a column. The constraint must be a predicate and can refer to a single column, or multiple columns of a table. For a long time it was not available for developers and DBAs working with MySQL databases. Right until the latest 8.0.16 version of MySQL server where the long-awaited feature was introduced.

dbForge Studio for MySQL is a GUI tool for MySQL and MariaDB database development, management, and administration. The IDE allows you to create and execute queries, build visual database diagrams, develop and debug stored routines, automate database object management, analyze table data via an intuitive interface.
For more information about the recent release of dbForge Studio for MySQL, please visit https://blog.devart.com/apply-integrity-constraint-to-your-mysql-database-with-the-help-of-dbforge-studio.html

About Devart

Devart is one of the leading developers of database tools and administration software, ALM solutions, data providers for various database servers, data integration and backup solutions. The company also implements Web and Mobile development projects.
For additional information about Devart, visit https://www.devart.com/

Top comments (0)