Assigning Column default value as another Column

• ashishj

  SSC Veteran

  Points: 200

  More actions

  October 28, 2002 at 2:06 am

  #79847

  Hi,

  I am using SQL Server 2000. I have a database table as TABLE1. TABLE1 has following structure :

  PRI_KEY INT, IDENTITY(1,1),

  DESC VARCHAR(10),

  REF_KEY INT

  The PRI_KEY is the primary key for the table and is defined as int and IDENTITY(1,1).

  The issue is that I want to assign the default value of REF_KEY to the value of PRI_KEY. So whatever value PRI_KEY gets the REF_KEY should also get the same value as default.

  Can I do this?

  Thanks in advance.

  Ashish

• Oleg D

  SSC Veteran

  Points: 279

  More actions

  October 28, 2002 at 9:50 am

  #439608

  Since DEFAULT for column is defined as constant_expression then the only way to do it will be insteadof trigger.