Interested to Buy Any Domain ? << Click Here >> for more details...
what is the Surrogate key?and wt is the diff between Primary
key and Surrogate Key?
- 2 Answers
- 8373 Views
- I also Faced
- E-Mail Answers
Answer Posted / jayaraj
Primary key is a type of key where the data inside the
column should be unique and should not be null.we generally
use the primary key to access any of the rows of a table by
using the primary key column.when a table don't have a
primary key then we assign a primary key to the table which
is known as surrogate key for accessing any row of the
table. means the key will act like a primary key for the
table.
| Is This Answer Correct ? | 4 Yes | 16 No |
Post New Answer View All Answers
How we can compare two database data?
if no size is defined while creating the database, what size will the database have? : Sql server administration
Ways to improve the performance of a SQL Azure Database?
What is the purpose of linked server configuration in sql server?
What is 4nf in normalization form?
How many types of the database links?
What are different types of replication in sql server?
What is proper subset of candidate key?
Explain indexed views and partitioned view with their syntax.
What is the difference between Stored Procedures and triggers?
Explain primary key and foreign key constraints?
What is indexing explain it with an example?
What do you understand by a stored procedure?
what are user defined datatypes and when you should go for them? : Sql server database administration
What is tempdb in sql server?
