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
0
votes
2 answers

How to constrain a set of columns to all be NULL or all be NOT NULL

Lets say I have a table like so, id | first name | middle name | last name Now, the name columns can be NULL, but if any of the three, for example, first name is NOT NULL, then all three must be NOT NULL. How can I enforce this in Oracle?
Gary Holiday
  • 3,297
  • 3
  • 31
  • 72
0
votes
2 answers

Check constraint in User Defined Type Oracle

I need to create a type that can hold only positive numbers that are between 8 and 13 characters in length. Best I was able to come up with is this, but it doesn't work: CREATE OR REPLACE TYPE TYPE1 AS OBJECT ( TYPE1 NUMBER (13) ) FINAL; CREATE…
Jovan Jovanović
  • 82
  • 9
0
votes
1 answer

Validate number of rows depending on master row field value

I need to add a constraint to validate that number of rows referencing master table is lower than value in master row, e.g we have a table master(master_id int pk, max_val int) and slave(slave_id int pk, master_id fk ref master(master_id)) (so…
Azbesciak
  • 308
  • 4
  • 16
0
votes
0 answers

SQL - How to set a constraint on ALL columns but one efficiently?

Using SQL Plus, I am attempting to set a trigger that would prevent anyone from updating a table unless it's one specific column. It doesn't have to be necessarily a trigger. Say in a table of 6 columns, you want to only allow the users to update c3…
hisoka
  • 344
  • 3
  • 13
0
votes
1 answer

MariaDB CHECK constraint in VARCHAR

I am not sure what is wrong below: ALTER TABLE `my_bookmarks` ADD CONSTRAINT id_length CHECK (LENGTH(bookmark_id) = 36); Purpose: I want a GUID data in my primary key - bookmark_id. The SQL above runs successfully, and the constraint is not added…
Bimal Poudel
  • 1,214
  • 2
  • 18
  • 41
0
votes
1 answer

MariaDB Check Constraint only for new inserts?

Is possible to define a check constraint that will only will be validated for new inserts?
zeitiger
  • 177
  • 2
  • 11
0
votes
0 answers

How to show null values for a field based on a constraint

I seem to be having a hard time with creating a psql check script to choose whether or not to display a column of data for my row. I have a birthday column as date and a gender column as text. A constraint(s) needs to be created on the birthday…
TahoeTugboat
  • 1
0
votes
1 answer

Check constraints on two tables in Oracle

I have two tables with a one-to-one relationship (and relationship is mandatory from one side only). As follows: create table PRS ( id number(18) not null, common_code varchar2(10), constraint pk_prs primary key (id)); create table RLP { id…
Amir Pashazadeh
  • 7,170
  • 3
  • 39
  • 69
0
votes
0 answers

EF Core 1.1 Check Constraint (Min, Max Notation)

I'm trying to add a check constraint to a table via EF Core 1.1 using Code First. The only answer I found was defining my constraint in the migration in a way like this: migrationBuilder.Sql("ADD CONSTRAINT CK_Column CHECK (Column >= X);"); My…
Joe Sef
  • 1
0
votes
1 answer

add a check constraint for the column

Add a check constraint for the column, ONLY insert the values that didn't have any special characters except comma, space, full-stop and number in them? For example allows like: Group Co.,Ltd Should not allow ¿Abc is important
P Nayak
  • 39
  • 7
0
votes
1 answer

SQL Check constraint for date range

Given I have 2 db table columns VALID_FROM, VALID_TO and they form date range from domain perspective. How to make sure VALID_TO is not before VALID_FROM when being inserted? I assume check constraint could help. How would one look like for Oracle…
Patrik Mihalčin
  • 3,341
  • 7
  • 33
  • 68
0
votes
3 answers

Oracle SQL Check constraint between 2 tables

I got 2 tables, Persons and Relationships. The Persons table got only 2 fields for now: ID and Age. Relationships have 3 fields: Person_ID, Relative_ID and Relation What I wanna do is simple: on insertion\update to Relationships I want to check the…
Cars Data
  • 37
  • 4
0
votes
3 answers

SQL Server 2008: Restrict column value with respect to another column value

I have a table with 2 columns CREATE TABLE mytable ( x int y char(1) ) I would like to enforce constraint on y with respect to the value of x. For example, when x = 5 I want to have y='a', when x = 12 y = 'b' and so on. Is it possible to do in…
Timofey
  • 2,478
  • 3
  • 37
  • 53
0
votes
2 answers

Create Unique Constraint over function based index with existing duplicate values

I have a table with wrong data and I'd like to prevent new wrong data from being inserted while I fix data and find out what process or where is the sentence making this happen. I first made a UQ constraint over the columns that shouldn't be…
EAmez
  • 837
  • 1
  • 9
  • 25
0
votes
1 answer

How to Fetch the length of the column using a Instead of Trigger in SQL Server?

I am trying to fetch the length of a particular column in Instead of Trigger using LEN() function. I want to fetch the length of a column from inserted table and then compare the length using if else so that I can do the required actions. Here is…
Deep
  • 1
  • 2
1 2 3
…
41 42