Re: View to drop or not?

From: Armando (blba2k_at_nospamyahoo.com)
Date: 03/04/04 

Date: Thu, 4 Mar 2004 11:02:39 -0500

Views are dynamic and the data gets pulled together as needed.

If you're using a SELECT * on the table, the column will show up. If you're
SELECTing individual columns, then you'll need to ALTER the view in
order to make the column appear. I recommend ALTERing over
DROP and CREATE so you don't have to re-apply any permissions.

"Shaleen Chugh" <shaleen.chugh@the-web-works-co.uk> wrote in message
news:eAr1SDgAEHA.2292@TK2MSFTNGP12.phx.gbl...
> I have a view in SQL Server 2000 which uses 10 table joins.I have modified
> one table by adding a column to it.Does the view get refreshed on its own
or
> do I have to drop and recreate it?
> Its a simple view with no options used.
> Pls let me know.
>
> Thanks and Regards,
>
> Shaleen
>
>

Relevant Pages

  • Re: My own security subsystem
    ... will look in the permissions table and match the sql login with the ... 'permissions' in the profile, and if the query returns a value such as 2, ... Best Regards, ... except for the fact that I can't use NT domain groups. ...
    (microsoft.public.sqlserver.security)
  • Re: Cannot write to shared folder on W2K8 server
    ... After reading your latest post and Meinolf about how you cannot recreate my issues led me to try to recreate it myself. ... I created a new folder and share on C: and can write to it from my desktop. ... Which I still don't understand why it doesn't work especially if I had reapplied the share permissions and NTFS security. ... If that was the case, maybe removing the share and NTFS permissions, except for administrator, and then reapply the NTFS permissions, then the Share. ...
    (microsoft.public.windows.server.general)
  • Re: MGET command deletes files
    ... >> I then ftp. ... >> Can you double check and ensure the user doesn't have any permissions on ... >> Regards, ... >> Bernard Cheah ...
    (microsoft.public.inetserver.iis.ftp)
  • Re: Restoring the SiteDirectory
    ... >Just create another area and use the Sites Directory area ... >> will need to create a new Sites list or recreate a Site ... >> how to recreate the SiteDirectory anywhere. ... >> Best Regards, ...
    (microsoft.public.sharepoint.portalserver)
  • Site Groups for new Site
    ... groups by default (reader, member, designer and admin). ... Regards ... Kevin McCloskey wrote: ... > So for example I have a contributor group but have changed the default permissions for that group. ...
    (microsoft.public.sharepoint.portalserver)