answersLogoWhite

0

A View is similar to a Table and can be mistaken for a table by a novice application developer.

CREATE VIEW VIEW_NAME AS SQL QUERY

Here the SQL Query includes the Select query on a table that is to be displayed as a View.

The view is a read only structure that only displays contents from a table and the user cannot insert or update or delete any data in the underlying table.

Views are generally created to impose access restrictions to a specific subset of users whom you do not want to give full access but at the same time want them to view the data.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

How do you create views?

Views can be created in a database using the CREATE VIEW key wordEx:CREATE VIEW view_name ASSELECT column_name(s)FROM table_nameWHERE conditions


What does SQL CREATE VIEW achieve?

SQL CREATE VIEW achieves the creation of a table or tables in the SQL database. One can then create tables to the purpose they desire and fill them in with information.


When you create a blank database the table that Access creates for you contains one field named .?

If you create it in Design View, no field name is given. If you create it in Datasheet View it is called Field1.


How can you create table using datasheet view?

When you open Access, Select NEW. The New tab provides several ways that you can create a new database including "TABLE View" which then looks like a datasheet


Create view in SQL?

create view vw_active_employee as select * from employee where status = 'Active' after creating the view, view can be used as a table to see active employee. e.g. select * from vw_active_employee Basically we save sql as a database object, so that we can use that in future as a virtual table.


How is Microsoft a database?

Microsoft is the name of a company, not a database. It has a well known database application called Microsoft Access. It is a database because of its ability to store and manipulate data. It has the facility to create tables and enter data into them, write queries to view and manipulate data and create forms and reports for viewing data onscreen and on paper. It has many other capabilities that are standard in a database application, such as having a query language, being able to facilitate relationships and many other things.Microsoft is the name of a company, not a database. It has a well known database application called Microsoft Access. It is a database because of its ability to store and manipulate data. It has the facility to create tables and enter data into them, write queries to view and manipulate data and create forms and reports for viewing data onscreen and on paper. It has many other capabilities that are standard in a database application, such as having a query language, being able to facilitate relationships and many other things.Microsoft is the name of a company, not a database. It has a well known database application called Microsoft Access. It is a database because of its ability to store and manipulate data. It has the facility to create tables and enter data into them, write queries to view and manipulate data and create forms and reports for viewing data onscreen and on paper. It has many other capabilities that are standard in a database application, such as having a query language, being able to facilitate relationships and many other things.Microsoft is the name of a company, not a database. It has a well known database application called Microsoft Access. It is a database because of its ability to store and manipulate data. It has the facility to create tables and enter data into them, write queries to view and manipulate data and create forms and reports for viewing data onscreen and on paper. It has many other capabilities that are standard in a database application, such as having a query language, being able to facilitate relationships and many other things.Microsoft is the name of a company, not a database. It has a well known database application called Microsoft Access. It is a database because of its ability to store and manipulate data. It has the facility to create tables and enter data into them, write queries to view and manipulate data and create forms and reports for viewing data onscreen and on paper. It has many other capabilities that are standard in a database application, such as having a query language, being able to facilitate relationships and many other things.Microsoft is the name of a company, not a database. It has a well known database application called Microsoft Access. It is a database because of its ability to store and manipulate data. It has the facility to create tables and enter data into them, write queries to view and manipulate data and create forms and reports for viewing data onscreen and on paper. It has many other capabilities that are standard in a database application, such as having a query language, being able to facilitate relationships and many other things.Microsoft is the name of a company, not a database. It has a well known database application called Microsoft Access. It is a database because of its ability to store and manipulate data. It has the facility to create tables and enter data into them, write queries to view and manipulate data and create forms and reports for viewing data onscreen and on paper. It has many other capabilities that are standard in a database application, such as having a query language, being able to facilitate relationships and many other things.Microsoft is the name of a company, not a database. It has a well known database application called Microsoft Access. It is a database because of its ability to store and manipulate data. It has the facility to create tables and enter data into them, write queries to view and manipulate data and create forms and reports for viewing data onscreen and on paper. It has many other capabilities that are standard in a database application, such as having a query language, being able to facilitate relationships and many other things.Microsoft is the name of a company, not a database. It has a well known database application called Microsoft Access. It is a database because of its ability to store and manipulate data. It has the facility to create tables and enter data into them, write queries to view and manipulate data and create forms and reports for viewing data onscreen and on paper. It has many other capabilities that are standard in a database application, such as having a query language, being able to facilitate relationships and many other things.Microsoft is the name of a company, not a database. It has a well known database application called Microsoft Access. It is a database because of its ability to store and manipulate data. It has the facility to create tables and enter data into them, write queries to view and manipulate data and create forms and reports for viewing data onscreen and on paper. It has many other capabilities that are standard in a database application, such as having a query language, being able to facilitate relationships and many other things.Microsoft is the name of a company, not a database. It has a well known database application called Microsoft Access. It is a database because of its ability to store and manipulate data. It has the facility to create tables and enter data into them, write queries to view and manipulate data and create forms and reports for viewing data onscreen and on paper. It has many other capabilities that are standard in a database application, such as having a query language, being able to facilitate relationships and many other things.


What is the difference between design view from datasheet view?

A data sheet view shows the data in the database. It allows you to enter and edit the data, but you cannot change the format of the database. Design view allows you to create or change the table, form or any other database object.


How do you create a new database in MySQL?

The MySQL command is "CREATE DATABASE [dbname]" with "[dbname]" replaced with your desired database name.


How do you create a database?

In order to create a database link, the command CREATE DATABASE LINK is used. Depending on the requirement, private or public databases may be created.


Is the relational database an example of oracle database?

A relational database is a type of database design. Oracle is a brand of database. You can create a relational database using Oracle. You can also create relational databases using other database applications.


How do you create a database link?

In order to create a database link, the command CREATE DATABASE LINK is used. Depending on the requirement, private or public databases may be created.


What are the main function of a database system?

create the database

Trending Questions
Ashok Maulik Reputed electrical Engineer from Calcutta worked for various Consultants had experience in Generator Transformers.........? What makes a pendulum swing back and forth? How entities can be related to each other using primary and foreign keys? What are specialized computers that interconnect the thousands of computers that make up the Internet in order to transmit message parcels along available communication paths? What are the different types of database languages? What are the segments on a disk called? How many songs can be stored on a 500 gigabyte external hard drive? What provides multiple network ports for cables that converge in an electrical closet a patch panel b RJ-45 jack c terminal adapter d loopback port? What services does AAFES provide? What is paint application? The development of a national railway system? Who developed the basic concept of the atom? Star wars kotor 2 how do you get Darth revans robes? Is Card reader Writer input or output? Can you explain the concept of double saturation in organic chemistry and how it affects the reactivity of molecules"? How do you delete a Pixiv account? A network administrator is building a network for a small business that has 22 hosts the ISP has assigned only one internet routable IP address which IP address block can the network administrator use? What does empty the recycle bin mean? What is the active component that a patch cord is plugged into when it is attached to a network connected device such as a desktop computer? What is the purpose of the switch command switch port access vlan 99?