Yahoo Αναζήτηση Διαδυκτίου

Αποτελέσματα Αναζήτησης

1. stackoverflow.com › questions › 886786sql server - How to change a table name using an SQL query? -...

   stackoverflow.com › questions › 886786

   20 Μαΐ 2009 · SQL Server table name can be changed in two ways. Execute the below query, by using the system stored procedure sp_rename. EXEC sp_rename 'dbo.old_table_name','new_table_name'; Open SSMS and expand the database folder. Right-click on a table and click Rename.

2. www.sqlservertutorial.net › sql-server-basics › sql-server-rename-tableSQL Server Rename Table By Examples - SQL Server Tutorial

   www.sqlservertutorial.net › sql-server-basics › sql-server-rename-table

   • Αποθηκευμένο αντίγραφο

   In this tutorial, you have learned how to rename a table in a database using the sp_rename stored procedure and SQL Server Management Studio.

3. www.sqlshack.com › how-to-rename-tables-inHow to rename tables in SQL Server with the sp_rename command -...

   www.sqlshack.com › how-to-rename-tables-in

   • Αποθηκευμένο αντίγραφο

   7 Οκτ 2019 · How to rename a table in SQL Server. The sp_rename is a stored procedure which helps to rename tables in SQL Server and the usage syntax will be like the below: 1. sp_rename'old_table_name','new_table_name'

4. learn.microsoft.com › en-us › sqlRename tables (Database Engine) - SQL Server | Microsoft Learn

   learn.microsoft.com › en-us › sql

   • Αποθηκευμένο αντίγραφο

   22 Ιουλ 2024 · Applies to: SQL Server 2016 (13.x) and later Azure SQL Database Azure SQL Managed Instance. This article covers how to rename a table in a database. To rename a table in Azure Synapse Analytics or Parallel Data Warehouse, use RENAME OBJECT.

5. database.guide › rename-a-table-in-sql-server-t-sqlRename a Table in SQL Server (T-SQL) - Database.Guide

   database.guide › rename-a-table-in-sql-server-t-sql

   • Αποθηκευμένο αντίγραφο

   17 Δεκ 2020 · Rename a Table in SQL Server (T-SQL) In SQL Server, you can use the sp_rename stored procedure to rename an object, including a table. Most of the other major RDBMs allow you to rename a table with the ALTER TABLE statement, but this isn’t the case with SQL Server.

6. www.techonthenet.com › sql_server › tablesSQL Server: ALTER TABLE Statement - TechOnTheNet

   www.techonthenet.com › sql_server › tables

   This SQL Server tutorial explains how to use the ALTER TABLE statement in SQL Server (Transact-SQL) to add a column, modify a column, drop a column, rename a column or rename a table with syntax and examples.

7. popsql.dev › learn-sql › sql-serverHow to Rename a Table in SQL Server - PopSQL

   popsql.dev › learn-sql › sql-server

   • Αποθηκευμένο αντίγραφο

   Discover how to rename a table in SQL Server using the SP_RENAME stored procedure. Follow a simple syntax to change the table name efficiently.