Find computed columns in a table
-
Hi,
anyone knows how to create a script to get the column/s that have computed columns.
ThanK
-
for everybody:
select name from syscolumns
where id = object_id('nometabella')
and iscomputed=1
-
select distinct a.name from sysobjects a inner join syscolumns b on a.id=b.id and b.iscomputed=1
where a.xtype='U'
The above query will give the table names which contains atlease one computed column
-
Thank very much
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply