Interested to Buy Any Domain ? << Click Here >> for more details...
what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 89479 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
what is the system function to get current user's user id? : Sql server database administration
What are the High-Availability solutions in SQL Server and differentiate them briefly?
What is built-in function?
Where can you find the error log information? : sql server database administration
Explain indexed views?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
How to call stored procedure using http soap?
What is standby servers? Explain types of standby servers.
What do you understand by a view?
What is ms sql server triggers?
How can I check if a view exists in a sql server database?
Explain magic tables in sql server?
How do I view views in sql server?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
How to write a query with an inner join in ms sql server?
