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

Check Constraint Expression error

I'm trying to create a Check Constraint using SQL Server Management Studio 2012's wizard to allow a field to be null only if the tuple is not enabled, but I'm getting an Error validating constraint. The expression I'm trying to use is…
leobelones
  • 578
  • 1
  • 8
  • 24
0
votes
2 answers

How can I copy records between tables only if they are valid according to check constraints in Oracle?

I don't know if that is possible, but I want to copy a bunch of records from a temp table to a normal table. The problem is that some records may violate check constraints so I want to insert everything that is possible and generate error logs…
Rafael Piccolo
  • 2,328
  • 1
  • 18
  • 29
0
votes
1 answer

Relational Table with self-reference and ambiguous column

I'm writing a relational data model for a system which keeps track of a set of boxes rendered in a browser, each of which contains rendered images. Currently, there is one table: Box. Each row has x and y coordinate, width and height columns, as…
almailer
  • 45
  • 1
  • 6
0
votes
1 answer

How to write an alter table statement to add a constraint

I'm, new to SQL. I have created few tables: CREATE TABLE MAINTINANCE (Maint_mname char(10), Maint_date date, Maint_duedate date NOT NULL, Maint_mdesc char (15)); CREATE TABLE DESIGNERR (Dez_emp_number varchar(11), Dez_field…
user1804219
  • 1
  • 1
  • 2
0
votes
2 answers

Oracle - Check constraint maximum number of x words

I want to add a check constraint that checks whether a field has a maximum number of X white spaces " ". I couldn't find anything about it on the oracle website. Anybody knows whether that's possible? Maybe through a PL/SQL function?
bicycle
  • 8,315
  • 9
  • 52
  • 72
0
votes
1 answer

Oracle CHECK Constraint on Two Date String Variants

I am working with a legacy Oracle database that has columns containing date strings formatted as follows: 30-Apr-03 30-Apr-2003 The column data type is VARCHAR2(12) (although 11 would suffice). Both of these representations can appear in a single…
DavidRR
  • 18,291
  • 25
  • 109
  • 191
0
votes
1 answer

SQLAlchemy: CheckConstraint with string function

Trying to use sqlalchemy.schema.CheckConstraint in this way: themes2tags_table = Table('themes2tags', Base.metadata, Column('theme_id', String(32), ForeignKey('tags.id')), Column('tag_id', String(32), ForeignKey('tags.id')), …
Alexey Khoroshikh
  • 425
  • 4
  • 10
0
votes
1 answer

sub-queries inside check constraint

If I have a person table, with 2 fields (name and address). create table PERSON ( NAME VARCHAR2(50), ADDRESS VARCHAR2(100) ); How do I ensure that all people with the same address have different names. I was trying…
Jeffry Tanudjaja
  • 1
0
votes
1 answer

Add a tuple-based check to this relation

In relation Person (SSN, State, Name), add a tuple-based check: if a person’s State is NY, then the first three digits of his SSN has to be between ‘050’ and ‘134’. (Hint: use LEFT function in SQL). CREATE TABLE Person ( SSN INT PRIMARY…
CppLearner
  • 16,273
  • 32
  • 108
  • 163
-1
votes
1 answer

Can someone help? Im trying to create then modify a table. INSERT statement conflicted with the CHECK constraint "chk_Sex"

I am attempting to create a table then add and modify it. Below is how I created the table. The other part is the first record I attempted to add to the the table that has given me the check constrain Error Msg 547, Level 16, State 0, Line 1 The…
nightowl898
  • 21
  • 3
-1
votes
1 answer

Oracle SQL missing smth

Trying to build these tables and there's always an error or missing something, can someone help me? Where's max_mice i'm checking if it's inbetween those values and doesn't work why? Don't know what's wrong, already searched everywhere, don't know…
Miguel Ramalho
  • 3
  • 2
-1
votes
1 answer

How to make a check-constraint to control the data was inserted

I have a column named "ppl". How do I make a constraint for this column that the data inserted got to have 5 characters and start with "ppl" (the next 2 characters got to be numbers) I tried using CHECK but I don't know how to and not sure if it…
Gaylord
  • 1
-1
votes
1 answer

CHECK with ^[A-Z]{3}[0-9]{6}$ - SQL Server

CREATE TABLE PARTICIPANTE( pasaporte NVARCHAR(9) NOT NULL, nombre NVARCHAR(50) NOT NULL, sexo CHAR(1) NOT NULL, fecNac DATE NOT NULL, codPais NVARCHAR(3) NOT NULL, CONSTRAINT PK_PARTICIPANTE PRIMARY KEY (pasaporte), …
id-mello
  • 1
-1
votes
1 answer

How to prevent an INSERT into a SQL Server table if a value is not in another table?

Let's say I have two SQL Server tables. One contains "transient" data - records are inserted, updated, and deleted as the external data that populates the table changes. I have another table that uses data in that table, and I need to make sure that…
Eric Belair
  • 10,574
  • 13
  • 75
  • 116
-1
votes
1 answer

Use CHECK with LIKE in MySQL?

I'm new to mysql, my question is that is this correct? CREATE TABLE ... ( /* some definition ommitted. */ About varchar(300) NOT NULL DEFAULT '...', CHECK(About LIKE 'ABOUT: %, DATE: %') ); By searching, all results show LIKE within…
NeoZoom.lua
  • 2,269
  • 4
  • 30
  • 64
1 2 3
…
41 42