Navicat for SQLite table Check Knowledge essentials

Navicat for SQLite as a more common database management software, a lot of people will use it, but some users know little about it, many points are not very clear. The following is an introduction to the Navicat for SQLite table check knowledge points, check the limit is the most common type of restriction, allowing the specified value in a column must conform to a Boolean (truth) expression.

Navicat for SQLite

On the "Check" tab, simply click the Check field to edit it. Using the Check toolbar, users can create new, edit, or delete selected check fields. It is important to note that only SQLite 3.3.0 or later supports checking.

Navicat for SQLite

Use the name edit box to set the check name.

Check

In the Check edit box, set the conditions for the check, for example: "Field 1 > 0 and Field 2 > Field 1". "

Defined

Enter a definition for the check limit.

For more related tutorials on Navicat for SQLite, refer to Navicat Chinese website .

The above is reproduced content, the original is: http://www.formysql.com/jiqiao/SQLite-biaojiancha.html

Navicat for SQLite table Check Knowledge essentials