What is the datatype of the surrgate key

  • Interview Candidate
  • 12
  • 2934

Showing Answers 1 - 12 of 12 Answers

ub

  • Jul 25th, 2006
 

datatype of the surrgate key is either inteeger or numaric or number

  Was this answer useful?  Yes

Pavan Nadiger

  • Aug 23rd, 2006
 

Normally Surrogate keys are sequencers which keep on increasing with new records being injected into the table. The standard datatype is integer

  Was this answer useful?  Yes

Sahitya Bindu

  • Sep 12th, 2006
 

Since Surrogate Keys are generated sequentially by the system the datatype should be of numeric type.

  Was this answer useful?  Yes

hari

  • Nov 25th, 2006
 

data type is:  INT4  LENGTH:  10 DECIMAL PLACE: 0 (zero)

  Was this answer useful?  Yes

ankitmohansharma

  • Jan 7th, 2008
 

Hi all,
Surrogate key is mostly a sequential number. Although it doesn't has to be.
They are system-generated artificial primary key values.
Typically, every row would have both a primary key and a surrogate key. The primary key identifies the unique row in the database, the surrogate key identifies the unique entity in the modelled world.
-Ankit

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions