computed column

• Ananda Kumar

  SSCommitted

  Points: 1865

  More actions

  May 20, 2005 at 3:28 am

  #66544

  Hi,

  How to find the columns involved in a computed column without string manipulation?

  I want only the column list with comma separated value.

   

  thanks

• Dinand Veldman

  SSC Enthusiast

  Points: 152

  More actions

  May 20, 2005 at 5:11 am

  #560140

  Hi,

  Can you be more specific in you question, maybe including an example?

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  May 20, 2005 at 6:55 am

  #560169

  Here's something to get you started - these will give you a list of computed columns from all the user tables:

  SELECT syscolumns.name FROM syscolumns

  JOIN sysobjects ON sysobjects.id = syscolumns.id

  AND syscolumns.iscomputed = 1 AND sysobjects.xtype = 'U'

  Hope this is what you were asking for!

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  May 20, 2005 at 7:10 am

  #560187

  Ananda - pl. follow this link for comma separated list...

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=174305#bm174355

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**