SQL Server: Computed Column defintions retrievable from Database?
This works in SQL Server 2008
create table dbo.Foo(StartDate int,CallDT AS (CONVERT([datetime],dateadd(second,[StartDate],'01/01/1970'),(0))))select definition from sys.computed_columns where name='CallDT' and object_id=object_id('dbo.Foo')
Try this:
SELECT name, definition FROM sys.computed_columnsShould work in SQL Server 2005 and newer.