Reports information on the computed columns in a specified table.
sp_helpcomputedcolumn {tabname}
names the table that contains computed columns.
This example reports the computed columns in the mytitles table:
sp_helpcomputedcolumn mytitles
Column_Name Property ----------- ------------ sum_sales materialized Text ------------------------------------ AS price * total_sales materialized (return status = 0)
Any user can use sp_helpcomputedcolumn.
Values in event and extrainfo columns from the sysaudits table are:
Event |
Audit option |
Command or access audited |
Information in extrainfo |
---|---|---|---|
38 |
exec_procedure |
Execution of a procedure |
|