我想知道视图是将数据存储为表还是调用时的视图 [英] I want to know view is store data as table or it view when it call

问题描述

我想知道查看商店数据，

当我执行时，

I want to know view store data,

when I execute,

select * from View

或它包含作为表的数据.

or It is contains data as table.

推荐答案

在数据库理论中，视图由存储的查询组成，可作为关系数据库中的虚拟表进行访问.视图不构成物理模式的一部分:它是根据数据库中的数据计算或整理的动态虚拟表.

请参考以下链接:

http://www.c-sharpcorner.com/UploadFile/6cde20 /concept-of-view-in-sql-server/ [ SQL Server中的视图 [http://en.wikipedia.org/wiki/View_(数据库) [

In database theory, a view consists of a stored query accessible as a virtual table in a relational database. A view does not form part of the physical schema: it is a dynamic, virtual table computed or collated from data in the database.

Refer below link:

http://www.c-sharpcorner.com/UploadFile/6cde20/concept-of-view-in-sql-server/[^]

Views In SQL Server[^]

http://en.wikipedia.org/wiki/View_(database)[^]

视图只是一个数据的逻辑表示.
数据仍存储在表中.

A view is only a logical representation of data.
Data is still stored in tables.

这篇关于我想知道视图是将数据存储为表还是调用时的视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！