0
View is a virtual table with no data of its own, but can be operated like any other table. It is like a window through which you can view data of another table, which is called the base table. syntax: CREATE VIEW table_name as SELECT statement ;
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
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
Which model represents the end user's view of the database?
the ---- of a database presents the views that the end user have
What are the different views of data in a database management systems?
In a database management system, data can be viewed in three main ways: Conceptual view: Represents the overall framework or structure of the entire database. External view: Shows a subset of the database and is tailored to meet individual user requirements. Physical view: Describes how data is stored on the physical storage media.
When was Gadfly - database - created?
Gadfly - database - was created in 1994.
When was Hibari - database - created?
Hibari - database - was created in 2010.
When was Gypsy - database - created?
Gypsy - database - was created in 2010.
When was BioModels Database created?
BioModels Database was created in 2005.
When was the autism database created?
The autism database - was created in 2010.
When was Database Nation created?
Database Nation was created in 2000.
When was Autophagy database created?
Autophagy database was created in 2010.
When was Domine Database created?
Domine Database was created in 2010.
When was ThYme - database - created?
ThYme - database - was created in 2010.
