Microsoft Fabric 中的 SQL 分析端点 Microsoft Fabric 中的仓库 在当前数据库中创建架构。 CREATE SCHEMA 事务还可以在新架构内创建表和视图,并可对这些对象设置 GRANT、DENY 或 REVOKE 权限。 Transact-SQL 语法约定 语法 syntaxsql -- Syntax for SQL Server and Azure SQL DatabaseCREATESCHEMAschema_name_clause...
schema_directory 是STRING 常值。 要在其中建立指定結構描述之檔案系統的路徑。如果基礎檔案系統中沒有指定的路徑,請建立具有路徑的目錄。 如果未指定位置,則會在預設倉儲目錄中建立結構描述,其路徑由靜態組態 spark.sql.warehouse.dir 所設定。 警告 如果在工作區層級 Hive 中繼存放區中註冊結構描述 (資料庫),...
syntaxsql 複製 CREATE CLUSTERED COLUMNSTORE INDEX index_name ON [ database_name . [ schema ] . | schema . ] table_name [ORDER (column[,...n])] [WITH ( DROP_EXISTING = { ON | OFF } )] [;] CREATE [ CLUSTERED | NONCLUSTERED ] INDEX index_name ON [ database_name . [ schema...
syntaxsql 複製 CREATE TABLE { database_name.schema_name.table_name | schema_name.table_name | table_name } ( { <column_definition> | [ ] [ ,... n ] | [ ] [ ,... n ] } [ PERIOD FOR SYSTEM_TIME ( system_start_time_column_name , system_end_time_column_name ) ] ) ...
syntaxsql კოპირება CREATE SYNONYM [ schema_name_1. ] synonym_name FOR ::= { [ server_name. [ database_name ] . [ schema_name_2 ] . | database_name. [ schema_name_2 ] . | schema_name_2. ] object_name } Azure SQL Database...
SQL Server 和 Azure SQL Database 的語法。 syntaxsql 複製 CREATE [ OR ALTER ] VIEW [ schema_name . ] view_name [ (column [ ,...n ] ) ] [ WITH <view_attribute> [ ,...n ] ] AS select_statement [ WITH CHECK OPTION ] [ ; ] <view_attribute> ::= { [ ENCRYPTION ] [ SCHE...
SQL Server Azure SQL 数据库 Azure SQL 托管实例 创建新的同义词。 Transact-SQL 语法约定 语法 SQL Server 语法: syntaxsql CREATESYNONYM[schema_name_1. ]synonym_nameFOR::={ [server_name. [database_name] . [schema_name_2 ] . |database_name. [schema_name_2 ] . |schema_name_2. ]object...
Syntax SQL Server syntax: syntaxsql Copy CREATE SYNONYM [ schema_name_1. ] synonym_name FOR ::= { [ server_name. [ database_name ] . [ schema_name_2 ] . | database_name. [ schema_name_2 ] . | schema_name_2. ] object_name } Azure SQL Database syntax: syntaxsql ...
The CREATE SCHEMA statement defines a schema at the current server and optionally creates tables, views, aliases, indexes, sequences, and distinct types. Comments and labels may be added in the catalog description of these objects, and privileges can be
The CREATE SCHEMA statement defines a schema at the current server and optionally creates tables, views, aliases, indexes, sequences, and distinct types. Comments and labels may be added in the catalog description of these objects, and privileges can be