Get a list of the col with a specific data types

• SD1999

  Hall of Fame

  Points: 3140

  More actions

  March 25, 2003 at 1:37 pm

  #101416

  I know it's a shame, please remind me how

  I can get a list of the columns from specific database where datatype is real(for example).

  I know you guys know everything 🙂

  Thank you!

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  March 25, 2003 at 1:59 pm

  #452114

  select col.name as ColName, obj.name as TableName, typ.name as DataType

  from syscolumns col, systypes typ, sysobjects obj

  where col.xtype = typ.xtype

  and col.id = obj.id

  and typ.xtype = 59

  and obj.xtype = 'U'

  order by obj.name, col.name

  xtype 59 is datatype real. You can find data type code from systypes table.

  Edited by - Allen_Cui on 03/25/2003 2:01:06 PM

• SD1999

  Hall of Fame

  Points: 3140

  More actions

  March 26, 2003 at 6:42 am

  #452175

  Thank you, very much!!!!!!!!!