Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main difference between constraints(like
primary key etc..)& joins?
- 2 Answers
- 6205 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
How do I find the size of a sql server database?
How to write character string constants or literals in ms sql server?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What is "scheduled jobs" or "scheduled tasks"?
What is the recovery model? List the types of recovery model available in sql server?
What are the recovery models in sql server 2000?
Can you explain various data region available in ssrs with their use?
Explain what is scheduled job and how to create it?
What is intellisense?
optimization techinques
What are the restraints imposed on the table design by a merge replication?
How to check table values in sql server?
How can you start sql server in different modes?
What is the meaning of resultset type_scroll_insensitive?
What is the difference between push and pull subscription? : sql server replication
