what is the main difference between constraints(like
primary key etc..)& joins?
Answer Posted / monal
Constraints are restrictions to make sure that data entered
in a table must meet certain crietria. You can put
constraint at either table level or column level. There are
5 types of constraints. Primary Key, Foregin Key, Unique,
Check and NOT NULL.
Joins are used to combine rows from one or more table. One
table using Self Join and More tables using inner join,
outer join, cross join.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How can change procedure in sql server?
What is implicit cursors?
Explain what is scheduled job and how to create it?
How to recover from sql injection? : sql server security
What is postgresql server?
What is a raid and what are different types of raid configurations?
How can we delete Duplicate row in table?
Explain Reporting Life Cycle?
How to change the password of a login name in ms sql server?
Explain what are partitioned views and distributed partitioned views?
What are the types of database schema? : sql server analysis services, ssas
What is the Disadvantage of indexed sequential file.
When would you use the stored procedures or functions?
How do I uninstall sql server 2014?
What are the advantages of user defined function?