sp_updateextendedproperty

25 Aug 2005 8:11 PM

Ned

Hi,

I am trying to update the extended property description for a column using
the sp_updateextendedproperty. However, I am not sure what to pass to the
@name parameter.

I have tried 'Description' and 'MS_Description' but neither works. The
schema is dbo, table name is activity_code and the column name =
activity_code_key.

EXEC sp_updateextendedproperty
@Name = N'MS_Description', @value = 'Primary key of the activity_code
table.',
@level0type = N'Schema', @level0name = dbo,
@level1type = N'Table', @level1name = activity_code,
@level2type = N'Column', @level2name = activity_code_key

Any help would be appeciated.

Regards,

Ned

25 Aug 2005 8:34 PM

Gail Erickson [MS]

Hi Ned,

It sounds like the name value was set to something other than Description or
MS_Description. You can get the current value for the Name property by
executing this statement:

USE <db_name>;
GO
SELECT objtype, objname, name, value
FROM fn_listextendedproperty (NULL, 'schema', 'dbo', 'table',
'activity_code', 'column', 'activity_code_key');

--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights

Show quote

"Ned" <ned.radeno***@medshare.com> wrote in message
news:umOksEbqFHA.2596@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> I am trying to update the extended property description for a column using
> the sp_updateextendedproperty. However, I am not sure what to pass to
> the @name parameter.
>
> I have tried 'Description' and 'MS_Description' but neither works. The
> schema is dbo, table name is activity_code and the column name =
> activity_code_key.
>
> EXEC sp_updateextendedproperty
> @Name = N'MS_Description', @value = 'Primary key of the activity_code
> table.',
> @level0type = N'Schema', @level0name = dbo,
> @level1type = N'Table', @level1name = activity_code,
> @level2type = N'Column', @level2name = activity_code_key
>
>
> Any help would be appeciated.
>
> Regards,
>
> Ned
>