SQL CHECK Constraints: A Step-by-Step Tutorial

preview_player
Показать описание
Learn how to add a SQL CHECK constraint to your database tables to validate data. This video will show you how to add a CHECK constraint to ensure that the mobile_number column in a Customer table contains a valid 10-digit number.

-------------------------------------------------------------------------
►►►Social Media – Where I sort of Live
-------------------------------------------------------------------------
►►►Books I refer to
-------------------------------------------------------------------------
►►►Camera Gears
► Video Gears That We Use For Creating Our YouTube Video

► Work From Home Essential Tech That We Use Daily

AFFILIATE DISCLOSURE:
#RebellionRider #coding #sql
Рекомендации по теме
Комментарии
Автор

You have already used VARCHAR(10) which is already a constraint, what is the purpose of using ADD constraint to that same column?

muhammadomer
Автор

i have a doubt that greater than 10 also displaying the error is yes or no

chandudatta
Автор

How can mobile number be VARCHAR data type?

deepakaggarwal
join shbcf.ru