To run this command, you need this permission: ] | ] table_name COLUMN column_name TO new_column_nameĬhange the name of a column in a table. You can't rename a database to any of the following Analytics Platform System (PDW) reserved database names: RENAME DATABASE [ database_name TO new_database_nameĪpplies to: Analytics Platform System (PDW)Ĭhange the name of a user-defined database from database_name to new_database_name. Specify the new table new_table_name as a one-part name. Specify the table to be renamed with a one-, two-, or three-part name. ] | ] table_name TO new_table_nameĪpplies to: Azure Synapse Analytics, Analytics Platform System (PDW)Ĭhange the name of a user-defined table. ] | ] table_name COLUMN column_name TO new_column_name Īrguments RENAME OBJECT. RENAME DATABASE database_name TO new_database_name Syntax for Analytics Platform System (PDW) Syntax - Syntax for Azure Synapse Analytics This syntax is not supported by serverless SQL pool in Azure Synapse Analytics.Renaming a dedicated SQL pool in Azure Synapse Analytics workspaces isn't currently supported. Renaming standalone dedicated SQL pools (formerly SQL DW) is supported.To rename a database in Azure SQL Database, use the ALTER DATABASE (Azure SQL Database) statement.To rename a database in SQL Server, use the stored procedure sp_renamedb.This article applies to Azure Synapse Analytics and Analytics Platform System (PDW) only: Renames a user-created table, a column in a user-created table or database in Analytics Platform System (PDW). Renames a user-created table in Azure Synapse Analytics.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |