Syntax 引數 備註 可更新的檢視 顯示其他 9 個 適用於:SQL Server Azure SQL 資料庫 Azure SQL 受控執行個體Azure Synapse Analytics Analytics Platform System (PDW) SQL 分析端點在 Microsoft Fabric SQL 資料庫中Microsoft網狀架構倉儲中的 SQL 分析端點Microsoft網狀架構 建立由查詢定義其內容 (資料行和資...
Transact-SQL 语法约定 语法 SQL Server 和 Azure SQL 数据库 的语法。 syntaxsql CREATE[ORALTER]VIEW[schema_name. ]view_name[ (column [ ,...n ] ) ] [WITH<view_attribute>[ ,...n ] ]ASselect_statement[WITHCHECKOPTION] [ ; ]<view_attribute>::={ [ENCRYPTION] [SCHEMABINDING] [VIEW_META...
SQL Dropping a View A view is deleted with theDROP VIEWstatement. SQL DROP VIEW Syntax DROPVIEWview_name; The following SQL drops the "Brazil Customers" view: Example DROPVIEW[Brazil Customers]; Track your progress - it's free! Log inSign Up...
SQL Server Reporting Services, Power View Index .5in is not a valid unit designator. Valid unit designators are in, mm, cm, pt, pc. 'No such host is known' error when configuring Reporting database 'Oracle' data extension not registered 'Return' statement in a Function,Get,or Operator ...
syntaxsql sp_refreshview[ @viewname = ]'viewname'[ ; ] Arguments [@viewname= ] 'viewname' The name of the view.@viewnameisnvarchar, with no default.@viewnamecan be a multipart identifier, but can only refer to views in the current database. ...
In this article Syntax Arguments Return code values Remarks Show 3 more Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Updates the metadata for the specified non-schema-bound view. Persistent metadata for a view can become outdated because of changes to the underlying...
QuotedIdentifierStatus Gets or sets a Boolean property value that specifies whether identifiers delimited by double quotation marks are Transact-SQL reserved keywords or contain characters not usually allowed by the Transact-SQL syntax rules. ReturnsViewMetadata Gets or sets a Boolean property value that...
Syntax for ALTER VIEW ALTER VIEWview-nameREGENERATE USINGAPPLICATION COMPATIBILITYapplcompat-levelDescription for ALTER VIEWview-nameIdentifies the view to be regenerated. The name must identify a view that exists at the current server.REGENERATE
A reason to specifyTEMPTABLEexplicitly is that locks can be released on underlying tables after the temporary table has been created and before it is used to finish processing the statement. This might result in quicker lock release than theMERGEalgorithm so that other clients that use the view ...
TheWITH CHECK OPTIONclause can be given for an updatable view to prevent inserts to rows for which theWHEREclause in theselect_statementis not true. It also prevents updates to rows for which theWHEREclause is true but the update would cause it to be not true (in other words, it prevents...