Computed Column

Is there a query that can be run to return all the tables in a database that
contain a computed column?
We are running SQL 2005, SP1, on Windows 2003.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server/200612/1
SELECT DISTINCT object_name(object_id)
FROM sys.computed_columns
Roy Harvey
Beacon Falls, CT
On Fri, 01 Dec 2006 21:38:16 GMT, "cbrichards via droptable.com"
<u3288@.uwe> wrote:

>Is there a query that can be run to return all the tables in a database that
>contain a computed column?
>We are running SQL 2005, SP1, on Windows 2003.

Computed Column

Is there a query that can be run to return all the tables in a database that
contain a computed column?
We are running SQL 2005, SP1, on Windows 2003.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200612/1SELECT DISTINCT object_name(object_id)
FROM sys.computed_columns
Roy Harvey
Beacon Falls, CT
On Fri, 01 Dec 2006 21:38:16 GMT, "cbrichards via droptable.com"
<u3288@.uwe> wrote:

>Is there a query that can be run to return all the tables in a database tha
t
>contain a computed column?
>We are running SQL 2005, SP1, on Windows 2003.