Thursday, March 22, 2012

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 SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-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 SQLMonster.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.

No comments:

Post a Comment