answersLogoWhite

0

View is a virtual table that do not have any data of its own but have data that is derived from another table called base table. Create view is the command used to create a view (virtual table).

User Avatar

Wiki User

10y ago

What else can I help you with?

Continue Learning about Computer Science

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.


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 do you view all the tables created in the database?

View is a virtual table with no data , but can be operated like any other table. It is like a virtual table through which you can view data of another table, which is known as the base table. Syntax for creating a view- CREATE VIEW as SELECT statement ;


Why create view in database?

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.


Will view drop if table drop?

If the dropped table is a base table for a view , then dbms like oracle invalidates these dependent views but does not drop them. But you cannot use these unless you re-create the table.

Related Questions

What the different between x-ray view and projection?

view is from the beam while projaction is image from patient


A view is created with the create view view name command?

View is a virtual table with no data of its own. creating a view : create view taxpay as select * from employee where gross>5000;


You create web form that display a grid view the grid view data source is a dataset named dsorders the dataset contain two datatables named orders and orderdetailsyou create a relation between the two?

newspaper


What is the difference between Photobucket and Flickr?

They are just different sites where you can view photos.


Where can one view comparisons of different camcorders?

One can view the comparisons of different camcorders at the website "consumerreports". The website offers detailed comparison between many camcorders.


What is the difference between Microsoft PowerPoint 2007 and Microsoft PowerPoint Viewer 2007?

The complete MS PowerPoint 2007 program allows you to create, edit, and view presentation files, while the Viewer only allows you to view the file (not create or edit).


What do the first three articles of the constitution create?

This question is kinda hard to understand. Maybe you could view different questions similar to it.


Why do anthers write from different points of view?

Anthers write from different points of view to provide readers with multiple perspectives and insights into a topic or a story. This allows for a deeper understanding of characters, themes, and emotions, and can create a more complex and engaging narrative. Writing from different points of view can also help to challenge stereotypes and biases by showing the diverse experiences and voices of different characters.


What view must you be in to create a form header for access?

Design view.


Which view is used to create a table or to modify the structure of the table?

Design view.


What is reletting?

Relative motion is : The comparison of motion between two different objects from the view of another object


What is the different view button?

what the different view button