Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com
Answertopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

Chapter 22. Views

Table of Contents

22.1. ALTER VIEW Syntax
22.2. CREATE VIEW Syntax
22.3. DROP VIEW Syntax

Views (including updatable views) are available in MySQL Server 5.1.

This chapter discusses the following topics:

  • Creating or altering views with CREATE VIEW or ALTER VIEW

  • Destroying views with DROP VIEW

Discussion of restrictions on use of views is given in Section I.4, “Restrictions on Views”.

To use views if you have upgraded to MySQL 5.1 from an older release that did not support views, you should upgrade your grant tables so that they contain the view-related privileges. See Section 5.5.2, “mysql_upgrade — Check Tables for MySQL Upgrade”.

Metadata about views can be obtained from the INFORMATION_SCHEMA.VIEWS table and by using the SHOW CREATE VIEW statement. See Section 23.15, “The INFORMATION_SCHEMA VIEWS Table”, and Section 13.5.4.8, “SHOW CREATE VIEW Syntax”.


 
 
  Published under the terms of the GNU General Public License Design by Interspire