declare @type varchar(64) SELECT @type= DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DRIVERS' and COLUMN_NAME ='DR_USER'

 

IF @type ='varchar'

 

print 'We are here!'

 

weblogs.sqlteam.com/joew/archive/2008/04/27/60574.aspx

SELECT
   ORDINAL_POSITION
  ,COLUMN_NAME
  ,DATA_TYPE
  ,CHARACTER_MAXIMUM_LENGTH
  ,IS_NULLABLE
  ,COLUMN_DEFAULT
FROM  
  INFORMATION_SCHEMA.COLUMNS
WHERE  
  TABLE_NAME = 'Product'
ORDER BY
  ORDINAL_POSITION ASC;

select * from syscolumns

where id=object_id('Customers')

ORDER BY

colid ASC