what is Constraint? How many types of constraints in SQL ?
Answer Posted / pramod tiwari,mba-it,lpu
SQL Constraints-
Constraints are used to limit the type of data that can go
into a table.
Constraints can be specified when a table is created (with
the CREATE TABLE statement) or after the table is created
(with the ALTER TABLE statement).
We will focus on the following constraints:
•NOT NULL
•UNIQUE
•PRIMARY KEY
•FOREIGN KEY
•CHECK
•DEFAULT
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
How to list all objects in a given schema?
Tell me what is log shipping?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
Do you know what are various aggregate functions that are available?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
What is sharding?
Write a sql query to sort on different column name according to the parameters passed in the function?
Explain following error properties?
What is coalesce in sql server?
How many types of functions are there in sql server?
Difference between group by clause and having clause in SQL?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
How you can get the list of largest tables in a database?
How to find table changes in sql server?
What are information schema views?