Find all columns in a table that are computed columns

Posted Date: 20 Nov 2008	Resource Type: Articles	Category: Databases
Author: gururajan	Member Level: Gold
Rating:	Points: 10

SQL SERVER 2000:

select name from syscolumns
where id =object_id('TableName')
and iscomputed=1

SQL SERVER 2005:

select name from sys.computed_columns
where object_id =object_id('TableName')

The computed column in SQL Server 2005 may be persisted. To narrow down the result set, you could execute the following query:

select * from sys.computed_columns
where is_persisted=0

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Find all columns .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: SQL Server Optimization Tips
	Previous Resource: Find all tables that have columns with an identity property
	Return to Discussion Resource Index
	Post New Resource
	Category: Databases

Post resources and earn money!

Related Resources