Thursday, April 13, 2006

Tables with computed columns

Computed columns some times causes re-indexing of database to fail. To find out which tables got computed columns, I normally use the following query.

select as ObjectId, as ObjectName, as ComputedColumnName
FROM sysobjects so, syscolumns sc
where =
and sc.iscomputed = 1
and so.xtype = 'u'

No comments: