On Wed, Aug 13, 2008 at 8:56 AM, John J. Mihaljevic
<[EMAIL PROTECTED]> wrote:
> Hi all,
>
> We've got an app running off-site.  Whenever I make changes to the structure
> of tables on my end, I've been writing little programs using commands such
> as ALTER TABLE to make the changes to the structure of the tables on the
> user's end.
>
> But what if I make changes to a view?  How do I transfer those changes to
> the user's site?

---------------------------------------

drop view viewName

create view YourSyntaxHere

go



-- 
Stephen Russell
Sr. Production Systems Programmer
Mimeo.com
Memphis TN

901.246-0159


_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to