What is Check Constraint in SQL Server - SQL Server / TSQL Tutorial Part 82

SQL Server / TSQL Tutorial Scenario:
What is Check Constraint :

Check Constraints limit the values that are accepted by one or more columns.

Let's understand Check Constraint with real time scenario.

You are working as SQL Server developer, You need to create dbo.Customer table which should have columns such as FName, LName and Address. As FName is going be be VARCHAR so the users can insert string values that can contain alphabets, numeric and other characters. You want to write a Check Constraint so FName only accepts alphabets.

Link to scripts used in SQL Server / TSQL Tutorial Video

Check out our website for Different SQL Server, MSBI tutorials and interview questions
such as SQL Server Reporting Services(SSRS) Tutorial
SQL Server Integration Services(SSIS) Tutorial
SQL Server DBA Tutorial
SQL Server / TSQL Tutorial ( Beginner to Advance)