what is the main difference between constraints(like primary key etc..)& j

what is the main difference between constraints(like
primary key etc..)& joins?

Question Posted / amit

2 Answers
5181 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the main difference between constraints(like primary key etc..)& joins?..

Answer / ravikiran

Constraints are the mechanisms used by the sql server to
control unwanted or invalid data flow into a table.

Joins are the queries used to combine the rows from two or
more tables.

Is This Answer Correct ?

2 Yes

0 No

what is the main difference between constraints(like primary key etc..)& joins?..

Answer / 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