Interested to Buy Any Domain ? << Click Here >> for more details...
what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 90780 Views
- HCL, IBM, NIIT, Wipro, I also Faced
- E-Mail Answers
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
What are the different types of collation sensitivity in sql server?
Define right outer join?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What is RAID? What are the different types of RAID configurations?
What is sqlcmd?
Are resultset updatable?
How does stuff differ from the replace function?
what is an index? : Sql server database administration
Can two tables share the same primary key?
What is a heap?
What is a data source file?
What is sql server transaction log file?
Does server sql treat char as a variable-length or fixed-length column?
How to round a numeric value to a specific precision?
What is recompile sql server?
