MySQL Forums
Forum List  »  MySQL Workbench

Re: Views and Routines
Posted by: Jay Alverson
Date: February 28, 2009 08:14AM

1. Views generally are snapshots of existing tables and do maybe small amounts of processing. Routines are Stored Procedures or Functions or other pieces of code that generally only work with the data, although you can do almost anything with them. Views mostly show data in certain perspectives, Routines manipulate the data in some (often) extravagant way.

2. Sure.

3. Sure. Consult the documentation for exactly what's kosher inside a given Routine.

4. Just preference. There's also privileges and separate ones for Routines vs Views, so it may be preferential to give someone the ability to use a View versus giving them the ability to use Routines -- which potentially could screw-up data.

5. Find out the version and consult the documentation.

6. Ask your DBA. Potentially every database environment can be different in a variety of ways.


Thanks, Jay

Options: ReplyQuote

Written By
February 28, 2009 07:08AM
Re: Views and Routines
February 28, 2009 08:14AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.