what is the main difference between constraints(like
primary key etc..)& joins?
- 2 Answers
- 5167 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
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
What is the difference between having clause and where clause in sql server?
Does partitioning improve performance?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
What is the difference between an index and a unique index?
What is the difference between osql and query analyzer?
What is update locks?
What does it mean to invest in the index?
How many types of the database links?
What is difference between unique and primary key?
How to select an exiting database using mssql_select_db()?
How to move database physical files in ms sql server?
Do you know what are the reporting services components?
What is the use of partition by in sql server?
Define Unique Key?
