0
Want this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
What is the different between a view and a create view?
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).
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 ;
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.
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.
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.
What is Table View's population?
The population of Table View is 23,445.
Which view is used to create a table or to modify the structure of the table?
Design view.
What is the different between a view and a create view?
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).
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 ;
When was Table View High School created?
Table View High School was created in 1986.
How many table views are available in MS Access?
There are two main view Datasheet View AND Desing View OTHER'S Pivot Table View Pivot Chart View
What is data view?
Is a logical description of some portion of database that is required by user to perform some task.
What virtual table in a database is known as a?
A view table.
What is the Branch Code for FNB Table View?
203-809 table view FNB branch code
What is the motto of Table View High School?
Table View High School's motto is 'Optima Petamus'.
What is the advantage of a graph compared to a table?
A graph is a visual view of data; a table is the numerical view of data.
What are the commands of view?
View is a virtual table with no data, but can be operated like any other table. creating a view : create view employee as select * from emp where gross>10000; dropping a view: drop view employee
