Re: Removing custom properties

Ah, it's per column...got it. I always thought that was stored at the view
level as an array or string or something.

Any suggestions on how to remove them en masse instead of going one-by-one?



Rob

"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:%23jOqD8zEHHA.4740@xxxxxxxxxxxxxxxxxxxxxxx
It's there. Extended properties can be attached to the view or to a
column of the view. I suppose that you have looked at the wrong place;
replace VIEW1 with the name of your view and take a look:

SELECT *, sql_variant_property(value, 'basetype') AS type FROM
::fn_listextendedproperty(NULL,N'user',N'dbo',N'view',N'VIEW1',NULL,NULL)

SELECT *, sql_variant_property(value, 'basetype') AS type FROM
::fn_listextendedproperty(NULL,N'user',N'dbo',N'view',N'VIEW1',N'column',NULL)
ORDER BY PATINDEX(N'MS_DisplayControl', name) DESC


--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Robert Morley" <rmorley@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:eBtLO2yEHHA.2312@xxxxxxxxxxxxxxxxxxxxxxx
Okay, so it turns out that what I was looking to remove isn't seen as an
extended property at all. What I'm trying to do is to reset (remove) the
Column Order that Access uses when it opens a view. Apparently SQL
Server sees that as a regular property, even though it pays no attention
to the property at all in the Enterprise Manager. Any thoughts on how to
do that...preferably "en masse"?



Thanks,
Rob





.

Relevant Pages

  • Re: Removing custom properties
    ... Sylvain Lafontaine, ing. ... Any suggestions on how to remove them en masse instead of going ... SELECT *, sql_variant_property(value, 'basetype') AS type FROM ... the Column Order that Access uses when it opens a view. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Removing custom properties
    ... Sylvain Lafontaine, ing. ... SELECT *, sql_variant_property(value, 'basetype') AS type FROM ... extended property at all. ... the Column Order that Access uses when it opens a view. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Removing custom properties
    ... Extended properties can be attached to the view or to a column ... SELECT *, sql_variant_property(value, 'basetype') AS type FROM ... Sylvain Lafontaine, ing. ... Column Order that Access uses when it opens a view. ...
    (microsoft.public.access.adp.sqlserver)
Loading