Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: check-constraints

CHECK Constraint to enforce upper case letter and pattern match

By adminPosted on February 3, 2023

Question : For one of my columns I am trying to enforce a pattern. The first letter should be D […]

PostgreSQL – Removing Unused Index on Check Constraint column

By adminPosted on January 17, 2023

Question : I used the script from this blog to identify the unused index on my database. It returns an […]

CHECK constraint for array column to verify length > 0

By adminPosted on January 14, 2023

Question : I’m playing with postgres table validation rules and trying to set a CHECK constraint for an array column. […]

Adding a check constraint on a new column with default value on a large table

By adminPosted on December 25, 2022

Question : I have a large table (1–2m rows) and need to add a column. It is an integer column […]

Fire a trigger function when checks change

By adminPosted on November 21, 2022

Question : I have the following use case: I have a set of different checks on different tables in one […]

MySQL – is there a way to implement a CHECK constraint after creating the table?

By adminPosted on November 3, 2022

Question : I created a table and after entering all the data, I found that I had missed a CHECK […]

What happens when play with constraints [closed]

By adminPosted on October 11, 2022

Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]

How to implement an association with restrictions

By adminPosted on October 7, 2022

Question : I’m working on an SQL database of useful plants. I’d like to be able to allow users to […]

Building a conditional check constraint

By adminPosted on August 23, 2022

Question : I’m trying to build a conditional check constraint for my table TBL_AFIL, which has two fields: Fec_Renun DATE […]

Postgres: How is SET NOT NULL “more efficient” than CHECK constraint

By adminPosted on August 12, 2022

Question : In PostgreSQL docs for Constraints, it says A not-null constraint is functionally equivalent to creating a check constraint […]

  • 1
  • 2
  • 3
  • …
  • 6

Recent Posts

  • What’s the benefit of CROSS JOIN vs INNER JOIN in recursive CTE queries?
  • Mongoexport halts when it reaches 101 records
  • A Script to insert dummy Data in all tables of DB [duplicate]
  • Will query continue to run even after network times-out
  • Need some support on MySQL Query
  • The sort column must be the last column used in the index – MongoDB Indexing Advice
  • Understanding Backup Types
  • SQL Server sp_configure options?
  • DBA Permissions on LOCAL SERVER containing SQL SERVER [closed]
  • Update table using values from another table in SQL Server
  • Getting 0KB of size file while backup mysql database using mysql dump [closed]
  • Local Backup from Amazon RDS PostgreSQL database
  • Who is using my worker threads? SQL Server 2014 – HADR
  • Data Domain Boost viewing backups
  • One table for all persons
  • Database for building a realtime analytics system
  • Threads_cached 0 while thread_cache_size > 0
  • Why is performance non-linear if I do many UPDATEs in a single transaction
  • Mysql innoDB write operations are extremely slow
  • mysql_query expected [closed]

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding