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
- 8280 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 many columns can exist together per table?
How do I find the query plan in sql server?
What area unit the various kinds of info compression introduced in sql server 2008?
What is data block and how to define data block size?
What is the name of the Database which IBM mainframe uses?
Explain what is the main purpose of having conversation group?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
How to list all columns in a table using odbc_columns()?
What happens if strings are casted into wrong code pages in ms sql server?
Is natural join and equi join same?
what are the different types of replication you can set up in sql server? : Sql server database administration
Do you know the different ddl commands in sql?
Is null vs coalesce?
Explain about protocol layer present in SQL server?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
