What are constraints? Explain different types of
constraints?
Answer Posted / manish nagar
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).
NOT NULL
UNIQUE
PRIMARY KEY
FOREIGN KEY
CHECK
DEFAULT
Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
How to generate random numbers with the rand() function in ms sql server?
What are the properties of the transaction?
What do you understand by user-defined function in the sql server?
What is cached report?
What the class forname () does?
What are the benefits of filtered indexes?
Explain what are page splits? : SQL Server Architecture
What is the difference between value type and reference type?
Explain the creation and execution of a user-defined function in the sql server?
Define master database?
what is database replication? : Sql server database administration
What is constraints and its types?
What is a deadlock and what is a live lock?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
What are the types of database schema? : sql server analysis services, ssas