Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main difference between constraints(like
primary key etc..)& joins?
- 2 Answers
- 6224 Views
- I also Faced
- E-Mail Answers
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
What are the extra roles available in msdb? : sql server security
Does hive support indexing?
How to add code to the existing article (using improve article)?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
Can you explain what is indexed view? How to create it?
What is the difference between primary key and unique constraints?
Tell me what is difference between view and materialized view?
What is difference between join and natural join?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
Is there any difference between the primary key and unique key?
How many databases instances are there in sql server 2000?
What is read uncmmited?
Why we need to use secondry database file? though, we can do same work using primary database file also.
Do you know how to make remote connection in database?
What is the largest component inside a field?
