Interested to Buy Any Domain ? << Click Here >> for more details...
what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 88338 Views
- HCL, IBM, NIIT, Wipro, I also Faced
- E-Mail Answers
Answer Posted / m arunachalam
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 ? | 1 Yes | 0 No |
Post New Answer View All Answers
Why use “in” clause in sql server?
What is difference between stored procedure and user defined function?
What are different types of subquery?
What happens when transaction log is full?
What is code near application topology?
What are synonyms?
what are database files and filegroups? : Sql server database administration
mention different types of relationships in the dbms?
What is the simplest way to create a new database in ms sql server?
What is the difference between local and global temporary tables?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
What is log in sql server?
What does it mean to normalize data?
What are scalar functions in sql?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
