Stack Overflow
Stack Overflow

Questions tagged [check-constraints]

CHECK constraints enforce domain integrity by limiting the values that are accepted by one or more columns.

SQL CHECK constraints enforce domain integrity by limiting the values that are accepted by one or more columns.

You can create a CHECK constraint with any logical (Boolean) expression that returns TRUE or FALSE based on the logical operators. For example, the range of values for a salary column can be limited by creating a CHECK constraint that allows for only data that ranges from $15,000 through $100,000. This prevents salaries from being entered beyond the regular salary range. The logical expression would be the following: salary >= 15000 AND salary <= 100000.

624 questions
1
vote
1 answer

Use rexexp in check constraint Mysql

I want to add a check constraint on the primary key of the accomodatie table named code. This code has to start with 4 letters and end with 4 numbers (Abcd0123). I thought I could use a regexp for that in a check constraint like below: alter table…
Ronny Giezen
  • 557
  • 2
  • 10
  • 21
1
vote
2 answers

MySQL Error Code 3815 while trying to make a check constraint

Here is the table I am trying to make a constraint for: create table All_Events( event_id int not null auto_increment, event_name varchar(50), event_type int, event_catagory int, other_text varchar(20), event_description varchar(200), start_time…
Robertf
  • 21
  • 2
1
vote
1 answer

Complex Django CheckContraint won't migrate

I'm having issues running a Django (2.2) migration that contains a somewhat complex CheckConstraint, running over python 3.6.9. The underlying database is PostGIS 9.5. The Model: class Subscription(BaseModel): class Meta: constraints =…
phrfpeixoto
  • 191
  • 1
  • 2
  • 11
1
vote
1 answer

How to use a cast function in a check constraint in PostgreSQL

I want to check if the values in a column are in the range of 0 to 255, but the column's type is a char, so I'm trying to use a cast, but I get an error. This is my code: alter table poste add constraint chk_poste check ( cast(ad as int )ad_int …
marcnougnode
  • 11
  • 1
1
vote
1 answer

SQL: Is there is anyway to make the check constrain refer to another table

Lets say i have two tables, one for products and other for OrderDetails. I'm trying to make a check constraint that checking whether the user had inputted a number of quantity inside the OrderDetails table that has exceeded the number of quantity…
maghraby
  • 33
  • 5
1
vote
0 answers

Attach Partition takes more time even after adding check constraint

So basically we have a very large table in Postgres 11 DB which has hundreds of millions of data since the table was added. Now we are trying to convert it into a range based partition table based on created_at column (timestamp - not nullable). As…
Rohit Singh
  • 2,143
  • 3
  • 13
  • 16
1
vote
3 answers

MySQL check constraint violation

I'm creating a MySQL database using the Oracle SQL Developer. I have created a table for currencies where the Currency_Code column should contain a three character (alphabets only), capitalised currency code. When I try to add a value it says that…
Namit Deb
  • 15
  • 5
1
vote
3 answers

Can I allow only certain specific strings to be inputted for a table in Oracle 10G?

CREATE TABLE trial ( phone_number NUMBER(5) PRIMARY KEY; name VARCHAR2(20) ) In this table, I want a constraint such that, name inputted should be only 'trial','experiment' or 'test'.
user14842715
1
vote
1 answer

Oracle SQL - REGEXP_LIKE not working as expected in CHECK constraint

I'm using Oracle SQL and I want to add a CHECK constraint that checks a regular expression when I create a table. However, the REGEXP_LIKE function behaves differently from online RegEx testing tools. Suppose I want to create a table called Testing…
AnsonH
  • 2,460
  • 2
  • 15
  • 29
1
vote
1 answer

Check constraint in ms access

I am trying to execute this statement in ms access (SQL view) but this shows an error on check constraint and on numeric(3,2) .. when I remove (3,2) from numeric and remove last 2 constriant check then this executes successfully ... but I want to…
TimeToCode
  • 1,458
  • 3
  • 18
  • 60
1
vote
1 answer

How to substitute a variable when creating a check constraint?

I need to add a required field for newly added rows. However, it is undesirable to set the default value for old rows due to the large size of the table. I need to provide an automated script that will do this. I tried this, but it does not work: do…
Alew
  • 316
  • 4
  • 12
1
vote
1 answer

Prevent insertion of overlapping timestamp ranges to database

Hi there I hope anyone can help me. lets say that I have on my table the following name text startTime timestamp without time zone endTime timestamp without time zone here is what I am trying to do: I am trying to check if the time that…
user6138023
1
vote
1 answer

Tests with constraint checking errors not caught when using AbstractTransactionalSpringContextTests (rollback)

The majority of my integration tests use spring's AbstractTransactionalSpringContextTests to do a rollback instead of commiting to the database. This works well normally but because foreign key constraints are not applied until the commit stage…
Tom Carter
  • 2,938
  • 1
  • 27
  • 42
1
vote
1 answer

Create check constraint on HSTORE to maintain specific succession of data

Question is regarding check constraint on HSTORE field in Postgres. create table archives_seasonmodel (episodes hstore) This is very shortened version of table I have, but just for example its ok. Episodes contains data in the following…
Aleksei Khatkevich
  • 1,923
  • 2
  • 10
  • 27
1
vote
3 answers

Conditional Not Null Constraint

Is there a way to model the following behaviour with constraint checks (or other functions) in postgres SQL: I have two columns: oncost (boolean) oncostdescription (varchar) If oncost is true, i want oncostdescription to be mandatory (NOT NULL,…
Thomas Lang
  • 1,285
  • 17
  • 35
1 2 3
…
41 42