crackyourinterview.com


To improves our performance please Like Share Subscribe(Will boost us)

What is the default constraint in SQL
Question Posted on 26 May 2020Home >> DataBase >> sql questions >> What is the default constraint in SQL

What is the default constraint in SQL
First we will take basic definition of constraint it is used to specify the some sort of rules to process data and do some limitation to the data that will go to tables. Now comes to default constraint in sql.
There are certain condition when we need to put some default values to a specific column. And that values will be added to that column when no values is added in that column then default values is automatically put in that column.

SQL Syntax:-
create table stu1(col_id int, col1 varchar(20), col2 int default 50)
0
0



.


Most Visited Questions:-

Deep Learning Questions Answers
Below are the different Deep Leaning Questions and answer a More...

Continuous Integration Questions Answers
Below are the 20 odd questions for CI or Continuous Integra More...

Derived relationships in Association Rule Mining are represented in the form of __________.
Derived relationships in Association Rule Mining are repres More...

What is Gulpjs and some multiple choice questions on Gulp
Gulpjs is an open source whihc helps in building Javascript More...

Microservices Architecture Questions Answers
Below are the different questions on Microservices Architec More...




Other Important Questions

Define N in nvarchar and in nchar?

difference between drop and truncate command

difference between procedure and function

different types of databases in sql

Difference Between Update Lock and Exclusive Lock






@2014-2022 Crackyourinterview (All rights reserved)
Privacy Policy - Disclaimer - Sitemap