tsql renaming set 7

Kat-Campise · Kat-Campise · commit d55982d1fa1f · 2020-09-16T06:27:01.000-07:00
diff --git a/docs/t-sql/statements/drop-view-transact-sql.md b/docs/t-sql/statements/drop-view-transact-sql.md
@@ -35,7 +35,7 @@ monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-s
 ## Syntax  
   
 ```syntaxsql
--- Syntax for SQL Server, Azure SQL Database, and Azure SQL Data Warehouse
+-- Syntax for SQL Server, Azure SQL Database, and Azure Synapse Analytics
   
 DROP VIEW [ IF EXISTS ] [ schema_name . ] view_name [ ...,n ] [ ; ]  
 ```  
diff --git a/docs/t-sql/statements/drop-workload-classifier-transact-sql.md b/docs/t-sql/statements/drop-workload-classifier-transact-sql.md
@@ -58,4 +58,4 @@ DROP WORKLOAD CLASSIFIER wgcELTRole;
 ## See Also
 
 [CREATE WORKLOAD CLASSIFIER &#40;Transact-SQL&#41;](../../t-sql/statements/create-workload-classifier-transact-sql.md)</br>
-[SQL Data Warehouse Workload Classification](/azure/sql-data-warehouse/sql-data-warehouse-workload-classification)
+[[!INCLUDE[ssSDW](../../includes/sssdwfull-md.md)] Workload Classification](/azure/sql-data-warehouse/sql-data-warehouse-workload-classification)
diff --git a/docs/t-sql/statements/execute-as-transact-sql.md b/docs/t-sql/statements/execute-as-transact-sql.md
@@ -57,7 +57,7 @@ monikerRange: "= azuresqldb-current || >= sql-server-2016 || >= sql-server-linux
  Specifies the execution context to be impersonated is a login. The scope of impersonation is at the server level.  
   
 > [!NOTE]  
->  This option is not available in a contained database or SQL Database or SQL Data Warehouse.  
+>  This option is not available in a contained database or SQL Database or [!INCLUDE[ssSDW](../../includes/sssdwfull-md.md)].  
   
  USER  
  Specifies the context to be impersonated is a user in the current database. The scope of impersonation is restricted to the current database. A context switch to a database user does not inherit the server-level permissions of that user.  
@@ -91,7 +91,7 @@ monikerRange: "= azuresqldb-current || >= sql-server-2016 || >= sql-server-linux
  When used inside a module, specifies the statements inside the module are executed in the context of the caller of the module.
  When used outside a module, the statement has no action.
  > [!NOTE]  
->  This option is not available in SQL Data Warehouse.  
+>  This option is not available in [!INCLUDE[ssSDW](../../includes/sssdwfull-md.md)].  
   
 ## Remarks  
  The change in execution context remains in effect until one of the following occurs:  
diff --git a/docs/t-sql/statements/grant-transact-sql.md b/docs/t-sql/statements/grant-transact-sql.md
@@ -49,7 +49,7 @@ GRANT { ALL [ PRIVILEGES ] }
 ```  
   
 ```syntaxsql
--- Syntax for Azure SQL Data Warehouse and Parallel Data Warehouse  
+-- Syntax for Azure Synapse Analytics and Parallel Data Warehouse  
   
 GRANT
     <permission> [ ,...n ]  
diff --git a/docs/t-sql/statements/insert-transact-sql.md b/docs/t-sql/statements/insert-transact-sql.md
@@ -115,7 +115,7 @@ INSERT
 ```  
   
 ```syntaxsql
--- Syntax for Azure SQL Data Warehouse and Parallel Data Warehouse  
+-- Syntax for Azure Synapse Analytics and Parallel Data Warehouse  
 
 INSERT INTO { database_name.schema_name.table_name | schema_name.table_name | table_name }
     [ ( column_name [ ,...n ] ) ]  
diff --git a/docs/t-sql/statements/permissions-grant-deny-revoke-azure-sql-data-warehouse-parallel-data-warehouse.md b/docs/t-sql/statements/permissions-grant-deny-revoke-azure-sql-data-warehouse-parallel-data-warehouse.md
@@ -1,7 +1,7 @@
 ---
-description: "Permissions: GRANT, DENY, REVOKE (Azure SQL Data Warehouse, Parallel Data Warehouse)"
+description: "Permissions: GRANT, DENY, REVOKE (Azure Synapse Analytics, Parallel Data Warehouse)"
 title: "GRANT-DENY-REVOKE permissions"
-titleSuffix: "Azure SQL Data Warehouse"
+titleSuffix: "Azure Synapse Analytics"
 ms.custom: "seo-lt-2019​"
 ms.date: "08/10/2017"
 ms.prod: sql
@@ -16,7 +16,7 @@ author: VanMSFT
 ms.author: vanto
 monikerRange: ">= aps-pdw-2016 || = azure-sqldw-latest || = sqlallproducts-allversions"
 ---
-# Permissions: GRANT, DENY, REVOKE (Azure SQL Data Warehouse, Parallel Data Warehouse)
+# Permissions: GRANT, DENY, REVOKE (Azure Synapse Analytics, Parallel Data Warehouse)
 [!INCLUDE[applies-to-version/asa-pdw](../../includes/applies-to-version/asa-pdw.md)]
 
   Use [!INCLUDE[ssSDW](../../includes/sssdw-md.md)] or [!INCLUDE[ssPDW](../../includes/sspdw-md.md)]**GRANT** and **DENY** statements to grant or deny a permission (such as **UPDATE**) on a securable (such as a database, table, view, etc.) to a security principal (a login, a database user, or a database role). Use **REVOKE** to remove the grant or deny of a permission.  
@@ -36,7 +36,7 @@ monikerRange: ">= aps-pdw-2016 || = azure-sqldw-latest || = sqlallproducts-allve
 ## Syntax  
   
 ```syntaxsql
--- Azure SQL Data Warehouse and Parallel Data Warehouse  
+-- Azure Synapse Analytics and Parallel Data Warehouse  
 GRANT   
     <permission> [ ,...n ]  
     [ ON [ <class_type> :: ] securable ]   
diff --git a/docs/t-sql/statements/rename-transact-sql.md b/docs/t-sql/statements/rename-transact-sql.md
@@ -17,12 +17,12 @@ monikerRange: ">= aps-pdw-2016 || = azure-sqldw-latest || = sqlallproducts-allve
 Renames a user-created table in [!INCLUDE[ssSDW](../../includes/sssdw-md.md)]. Renames a user-created table, a column in a user-created table or database in [!INCLUDE[ssPDW](../../includes/sspdw-md.md)].
 
 > [!NOTE]
-> To rename a database in [!INCLUDE[ssSDW](../../includes/sssdw-md.md)], use [ALTER DATABASE (Azure SQL Data Warehouse](alter-database-transact-sql.md?view=aps-pdw-2016-au7). To rename a database in Azure SQL Database, use the [ALTER DATABASE (Azure SQL Database)](alter-database-transact-sql.md?view=azuresqldb-mi-current) statement. To rename a database in [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)], use the stored procedure [sp_renamedb](../../relational-databases/system-stored-procedures/sp-renamedb-transact-sql.md).
+> To rename a database in [!INCLUDE[ssSDW](../../includes/sssdw-md.md)], use [ALTER DATABASE ([!INCLUDE[ssSDW](../../includes/sssdwfull-md.md)])](alter-database-transact-sql.md?view=aps-pdw-2016-au7). To rename a database in Azure SQL Database, use the [ALTER DATABASE (Azure SQL Database)](alter-database-transact-sql.md?view=azuresqldb-mi-current) statement. To rename a database in [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)], use the stored procedure [sp_renamedb](../../relational-databases/system-stored-procedures/sp-renamedb-transact-sql.md).
 
 ## Syntax
 
 ```syntaxsql
--- Syntax for Azure SQL Data Warehouse
+-- Syntax for Azure Synapse Analytics
 
 -- Rename a table.
 RENAME OBJECT [::] [ [ database_name . [schema_name ] ] . ] | [schema_name . ] ] table_name TO new_table_name
@@ -87,7 +87,7 @@ You can't rename an external table, indexes, or views. Instead of renaming, you
 
 ### Cannot rename a table in use
 
-You can't rename a table or database while it is in use. Renaming a table requires an exclusive lock on the table. If the table is in use, you may need to terminate sessions that are using the table. To terminate a session, you can use the KILL command. Use KILL cautiously since when a session is terminated any uncommitted work will be rolled back. Sessions in SQL Data Warehouse are prefixed by 'SID'. Include 'SID' and the session number when invoking the KILL command. This example views a list of active or idle sessions and then terminates session 'SID1234'.
+You can't rename a table or database while it is in use. Renaming a table requires an exclusive lock on the table. If the table is in use, you may need to terminate sessions that are using the table. To terminate a session, you can use the KILL command. Use KILL cautiously since when a session is terminated any uncommitted work will be rolled back. Sessions in [!INCLUDE[ssSDW](../../includes/sssdwfull-md.md)] are prefixed by 'SID'. Include 'SID' and the session number when invoking the KILL command. This example views a list of active or idle sessions and then terminates session 'SID1234'.
 
 ### Rename column restrictions
 
@@ -150,7 +150,7 @@ ALTER SCHEMA dbo TRANSFER OBJECT::product.item;
 
 **APPLIES TO:** [!INCLUDE[ssSDW](../../includes/sssdw-md.md)], [!INCLUDE[ssPDW](../../includes/sspdw-md.md)]
 
-It is important to remember that you can't rename a table while it is in use. A rename of a table requires an exclusive lock on the table. If the table is in use, you may need to terminate the session using the table. To terminate a session, you can use the KILL command. Use KILL cautiously since when a session is terminated any uncommitted work will be rolled back. Sessions in SQL Data Warehouse are prefixed by 'SID'. You will need to include 'SID' and the session number when invoking the KILL command. This example views a list of active or idle sessions and then terminates session 'SID1234'.
+It is important to remember that you can't rename a table while it is in use. A rename of a table requires an exclusive lock on the table. If the table is in use, you may need to terminate the session using the table. To terminate a session, you can use the KILL command. Use KILL cautiously since when a session is terminated any uncommitted work will be rolled back. Sessions in [!INCLUDE[ssSDW](../../includes/sssdwfull-md.md)] are prefixed by 'SID'. You will need to include 'SID' and the session number when invoking the KILL command. This example views a list of active or idle sessions and then terminates session 'SID1234'.
 
 ```sql
 -- View a list of the current sessions
diff --git a/docs/t-sql/statements/restore-statements-transact-sql.md b/docs/t-sql/statements/restore-statements-transact-sql.md
@@ -958,8 +958,8 @@ Requires the `CREATE ANY DATABASE` permission.
 Requires a Windows account that has permission to access and read from the backup directory. You must also store the Windows account name and password in [!INCLUDE[ssPDW](../../includes/sspdw-md.md)].
 
 - To verify the credentials are already there, use [sys.dm_pdw_network_credentials](../../relational-databases/system-dynamic-management-views/sys-dm-pdw-network-credentials-transact-sql.md).
-- To add or update the credentials, use [sp_pdw_add_network_credentials - SQL Data Warehouse](../../relational-databases/system-stored-procedures/sp-pdw-add-network-credentials-sql-data-warehouse.md).
-- To remove credentials from [!INCLUDE[ssPDW](../../includes/sspdw-md.md)], use [sp_pdw_remove_network_credentials - SQL Data Warehouse](../../relational-databases/system-stored-procedures/sp-pdw-remove-network-credentials-sql-data-warehouse.md).
+- To add or update the credentials, use [sp_pdw_add_network_credentials - [!INCLUDE[ssSDW](../../includes/sssdwfull-md.md)]](../../relational-databases/system-stored-procedures/sp-pdw-add-network-credentials-sql-data-warehouse.md).
+- To remove credentials from [!INCLUDE[ssPDW](../../includes/sspdw-md.md)], use [sp_pdw_remove_network_credentials - [!INCLUDE[ssSDW](../../includes/sssdwfull-md.md)]](../../relational-databases/system-stored-procedures/sp-pdw-remove-network-credentials-sql-data-warehouse.md).
 
 ## Error Handling
 
@@ -982,7 +982,7 @@ After a restore, the user database will have database compatibility level 120. T
 
 ## Restoring to an appliance with a larger number of compute nodes
 
-Run [DBCC SHRINKLOG (Azure SQL Data Warehouse)](../../t-sql/database-console-commands/dbcc-shrinklog-azure-sql-data-warehouse.md) after restoring a database from a smaller to larger appliance since redistribution will increase transaction log.
+Run [DBCC SHRINKLOG ([!INCLUDE[ssSDW](../../includes/sssdwfull-md.md)])](../../t-sql/database-console-commands/dbcc-shrinklog-azure-sql-data-warehouse.md) after restoring a database from a smaller to larger appliance since redistribution will increase transaction log.
 
 Restoring a backup to an appliance with a larger number of Compute nodes grows the allocated database size in proportion to the number of Compute nodes.
 
diff --git a/docs/t-sql/statements/revoke-transact-sql.md b/docs/t-sql/statements/revoke-transact-sql.md
@@ -56,7 +56,7 @@ REVOKE [ GRANT OPTION FOR ]
 ```  
   
 ```syntaxsql
--- Syntax for Azure SQL Data Warehouse and Parallel Data Warehouse  
+-- Syntax for Azure Synapse Analytics and Parallel Data Warehouse  
   
 REVOKE   
     <permission> [ ,...n ]  
diff --git a/docs/t-sql/statements/set-ansi-null-dflt-off-transact-sql.md b/docs/t-sql/statements/set-ansi-null-dflt-off-transact-sql.md
@@ -42,7 +42,7 @@ SET ANSI_NULL_DFLT_OFF { ON | OFF }
 ```
 
 ```syntaxsql
--- Syntax for Azure SQL Data Warehouse and Parallel Data Warehouse
+-- Syntax for Azure Synapse Analytics and Parallel Data Warehouse
 
 SET ANSI_NULL_DFLT_OFF OFF
 ```
diff --git a/docs/t-sql/statements/set-ansi-null-dflt-on-transact-sql.md b/docs/t-sql/statements/set-ansi-null-dflt-on-transact-sql.md
@@ -42,7 +42,7 @@ SET ANSI_NULL_DFLT_ON {ON | OFF}
 ```
 
 ```syntaxsql
--- Syntax for Azure SQL Data Warehouse and Parallel Data Warehouse
+-- Syntax for Azure Synapse Analytics and Parallel Data Warehouse
 
 SET ANSI_NULL_DFLT_ON ON
 ```
diff --git a/docs/t-sql/statements/set-ansi-nulls-transact-sql.md b/docs/t-sql/statements/set-ansi-nulls-transact-sql.md
@@ -43,7 +43,7 @@ SET ANSI_NULLS { ON | OFF }
 ```
 
 ```syntaxsql
--- Syntax for Azure SQL Data Warehouse and Parallel Data Warehouse
+-- Syntax for Azure Synapse Analytics and Parallel Data Warehouse
 
 SET ANSI_NULLS ON
 ```
diff --git a/docs/t-sql/statements/set-ansi-padding-transact-sql.md b/docs/t-sql/statements/set-ansi-padding-transact-sql.md
@@ -42,7 +42,7 @@ SET ANSI_PADDING { ON | OFF }
 ```
 
 ```syntaxsql
--- Syntax for Azure SQL Data Warehouse and Parallel Data Warehouse
+-- Syntax for Azure Synapse Analytics and Parallel Data Warehouse
 
 SET ANSI_PADDING ON
 ```
diff --git a/docs/t-sql/statements/set-ansi-warnings-transact-sql.md b/docs/t-sql/statements/set-ansi-warnings-transact-sql.md
@@ -41,7 +41,7 @@ SET ANSI_WARNINGS { ON | OFF }
 ```
 
 ```syntaxsql
--- Syntax for Azure SQL Data Warehouse and Parallel Data Warehouse
+-- Syntax for Azure Synapse Analytics and Parallel Data Warehouse
 
 SET ANSI_WARNINGS ON
 ```
diff --git a/docs/t-sql/statements/set-arithabort-transact-sql.md b/docs/t-sql/statements/set-arithabort-transact-sql.md
@@ -45,7 +45,7 @@ SET ARITHABORT { ON | OFF }
 ```
 
 ```syntaxsql
--- Syntax for Azure SQL Data Warehouse and Parallel Data Warehouse
+-- Syntax for Azure Synapse Analytics and Parallel Data Warehouse
 
 SET ARITHABORT ON
 ```
diff --git a/docs/t-sql/statements/set-arithignore-transact-sql.md b/docs/t-sql/statements/set-arithignore-transact-sql.md
@@ -41,7 +41,7 @@ SET ARITHIGNORE { ON | OFF }
 ```
 
 ```syntaxsql
--- Syntax for Azure SQL Data Warehouse and Parallel Data Warehouse  
+-- Syntax for Azure Synapse Analytics and Parallel Data Warehouse  
 
 SET ARITHIGNORE OFF
 ```
diff --git a/docs/t-sql/statements/set-concat-null-yields-null-transact-sql.md b/docs/t-sql/statements/set-concat-null-yields-null-transact-sql.md
@@ -44,7 +44,7 @@ SET CONCAT_NULL_YIELDS_NULL { ON | OFF }
 ```  
   
 ```syntaxsql
--- Syntax for Azure SQL Data Warehouse and Parallel Data Warehouse  
+-- Syntax for Azure Synapse Analytics and Parallel Data Warehouse  
   
 SET CONCAT_NULL_YIELDS_NULL ON    
 ```  
diff --git a/docs/t-sql/statements/set-datefirst-transact-sql.md b/docs/t-sql/statements/set-datefirst-transact-sql.md
@@ -45,7 +45,7 @@ SET DATEFIRST { number | @number_var }
 ```  
   
 ```syntaxsql
--- Syntax for Azure SQL Data Warehouse and Parallel Data Warehouse  
+-- Syntax for Azure Synapse Analytics and Parallel Data Warehouse  
   
 SET DATEFIRST 7 ;  
 ```  
diff --git a/docs/t-sql/statements/set-quoted-identifier-transact-sql.md b/docs/t-sql/statements/set-quoted-identifier-transact-sql.md
@@ -44,7 +44,7 @@ SET QUOTED_IDENTIFIER { ON | OFF }
 ```
 
 ```syntaxsql
--- Syntax for Azure SQL Data Warehouse and Parallel Data Warehouse
+-- Syntax for Azure Synapse Analytics and Parallel Data Warehouse
 
 SET QUOTED_IDENTIFIER ON
 ```
diff --git a/docs/t-sql/statements/set-result-set-caching-transact-sql.md b/docs/t-sql/statements/set-result-set-caching-transact-sql.md
@@ -22,7 +22,7 @@ monikerRange: "=azure-sqldw-latest || = sqlallproducts-allversions"
 
 Controls the result set caching behavior for the current client session.  
 
-Applies to Azure SQL Data Warehouse  
+Applies to [!INCLUDE[ssSDW](../../includes/sssdwfull-md.md)]  
   
  ![Topic link icon](../../database-engine/configure-windows/media/topic-link.gif "Topic link icon") [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md)  
   
diff --git a/docs/t-sql/statements/set-statements-transact-sql.md b/docs/t-sql/statements/set-statements-transact-sql.md
diff --git a/docs/t-sql/statements/set-transaction-isolation-level-transact-sql.md b/docs/t-sql/statements/set-transaction-isolation-level-transact-sql.md
diff --git a/docs/t-sql/statements/truncate-table-transact-sql.md b/docs/t-sql/statements/truncate-table-transact-sql.md
diff --git a/docs/t-sql/statements/update-statistics-transact-sql.md b/docs/t-sql/statements/update-statistics-transact-sql.md
