what is the Surrogate key?and wt is the diff between Primary
key and Surrogate Key?
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 to add additional conditions in SQL?
What is the syntax for encrypting a column in SQL Server?
What is ddl command?
How to display a past time in days, hours and minutes?
What is a group function explain with an example?
How can I tell if sql server is 32 or 64 bit?
What is an sql server agent?
What are the different types of sql server replication? : sql server replication
What is it’s similarity with sql server?
How to count rows with the count(*) function in ms sql server?
How we can refresh the view?
What does it mean to manipulate data?
How global temporary tables are represented and its scope?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
Explain how you can deploy an SSRS report?