Fields that a calculated field depends on 1

[litton1]

HI all,

Any body know how to get at this info? tried sp_help table_name but it does not show up in there. Searched google but cannot find an answer to this.

Thanks.

Age is a consequence of experience

 

[bborissov]

SELECT * FROM sys.computed_columns

?

Borislav Borissov
VFP9 SP2, SQL Server

 

[bborissov]

Or from here:

http://msdn.microsoft.com/en-us/library/bb677315.aspx

SELECT OBJECT_NAME(referencing_id) AS referencing_entity_name, 
    o.type_desc AS referencing_desciption, 
    COALESCE(COL_NAME(referencing_id, referencing_minor_id), '(n/a)') AS referencing_minor_id, 
    referencing_class_desc, referenced_class_desc,
    referenced_server_name, referenced_database_name, referenced_schema_name,
    referenced_entity_name, 
    COALESCE(COL_NAME(referenced_id, referenced_minor_id), '(n/a)') AS referenced_column_name,
    is_caller_dependent, is_ambiguous
FROM sys.sql_expression_dependencies AS sed
INNER JOIN sys.objects AS o ON sed.referencing_id = o.object_id
WHERE  COALESCE(COL_NAME(referencing_id, referencing_minor_id), '(n/a)') = 'YourComputedFieldName'

Borislav Borissov
VFP9 SP2, SQL Server

 

[litton1]

bborissov - the second example did it for me thanks.

Have a star.




Age is a consequence of experience