可以在下列级别上授予 VIEW DEFINITION 权限: 服务器作用域 数据库作用域 架构作用域 单独实体 服务器作用域 在此作用域内授予的 VIEW ANY DEFINITION 权限,可有效地取消被授权者基于权限的元数据访问权限。这意味着被授权者可以查看 SQL Server 实例中的所有元数据,但在数据库作用域、架构作用域内或针对单独实体(...
Only the definition of a nonindexed view is stored, not the rows of the view. The query optimizer incorporates the logic from the view definition into the execution plan it builds for the SQL statement that references the nonindexed view. The logic used by the SQL Server query optimizer to...
When the member tables and partitioned view definition are in place, the SQL Server query optimizer builds intelligent plans that use queries efficiently to access data from member tables. With the CHECK constraint definitions, the query processor maps the distribution of key values across the member...
ADatabasePermissionobject that represents theViewDefinitionpermission that can be included in the database permission set. 示例 授予、撤消和拒绝权限 请参阅 参考 DatabasePermission 类 Microsoft.SqlServer.Management.Smo 命名空间 其他资源 权限(数据库引擎)...
关于SQL Server的view 今天就先发一篇数据库的基础文章,因为最近碰到过几个SQL Developer的工作,所以趁此机会把以前学校学的东西都拣拣。好了,废话不多说,进入正题吧。 首先View是干什么用的呢? Views allow you to create a virtual representation of table data using a SELECT statement as its definition....
Definition Namespace: Microsoft.SqlServer.Management.SqlParser.Parser Assembly: Microsoft.SqlServer.Management.SqlParser.dll Package: Microsoft.SqlServer.SqlManagementObjects v150.18208.0 C# publicstaticSystem.Collections.Generic.IDictionary<string,object>RetrieveViewDefinition(stringsql, Microsoft.SqlSer...
Email Server Profile Email Template Entity Entity Analytics Config Entity Image Configuration Entity Index Entity Key Entity link chat configuration Entity Relationship EntityRecordFilter EntityRefreshHistory Environment Variable Definition Environment Variable Value Event Expander Breadcrumb Exchange Sync Id Mapping...
A schema-bound dependency is created when a view or user-defined function is created by using the WITH SCHEMABINDING clause, or when a table references another object through a CHECK or DEFAULT constraint or in the definition of a computed column. Non-schema-bound dependency A non-schema-bound...
DefinitionNamespace: Microsoft.SqlServer.Management.Smo Assembly: Microsoft.SqlServer.Smo.dll Package: Microsoft.SqlServer.SqlManagementObjects v160.2004021.0 Instance class encapsulating : Server[@Name='']/Database/View C# 複製 [Microsoft.SqlServer.Management.Facets.EvaluationMode(Microsoft.SqlServer....
The ALTER VIEW statement regenerates a view using an existing view definition at the current server. ALTER VIEW is primarily used during Db2 migration or when Db2 maintenance is applied. To change a view definition (for example, to add additional columns