• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1939
  • Last Modified:

Use of sp_addextendedproperty to add descriptions on Tables & columns when Owner NOT dbo but PSEUDEOuser USER

How can I add descriptions to EITHER a table OR a column when the table owner is NOT dbo but DOES have db_owner role?

all of the examples given:

exec sp_addextendedproperty N'MS_Description', N'This is a description', N'user', N'dbo', N'table', N'table_name'

I want to assume that I do NOT know the username so it's not just N'other user' (in the 3rd to the end parmameter)
I really want to use the USER pseudo column and assume the one adding the description is the OWNER (this is a safe assumption to make)

1 Solution
I've never found it possible to do this (it's a little bit disappointing that descriptors aren't easier to work with in SQL).  Just a suggestion, since you have to call a proc to do it anyway, setup your "Meta Data" table and insert all your extended properties into this user create table--you have more options and more flexibility in the future using your own.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now