AlterEgo
3/27/2007 12:18:00 AM
Aamir,
This should work for you:
select
o.name
, c.name
, c.iscomputed
from sysobjects o
inner join syscolumns c on o.id = c.id
where ...
-- Bill
"Aamir Mahmood" <aba.def@efg.hij> wrote in message
news:eINnJDAcHHA.2088@TK2MSFTNGP05.phx.gbl...
> Hi,
>
> Could anyone please help me write a SQL 2000 compatible query for the
> following query. The following query runs perfectly on SQL 2005, but NOT
> on SQL 2000.
>
> ---
>
> select t.name, c.name, c.is_computed
> from sys.columns as c join sys.tables as t
> on c.object_id = t.object_id
> where c.is_computed = 1 and t.name = '<table_name>'
> ---
>
>