<div>
TO rename a table name please use below command-<br />
<br />
EXEC SP_RENAME '<b>schema</b>.oldtablename', 'newtablename'
</div>


TO rename a table name please use below command-

EXEC SP_RENAME 'schema.oldtablename', 'newtablename'

<div>
If you want to learn more about this command use below MS link - <a href="https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-rename-transact-sql" rel="ugc">https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-rename-transact-sql</a>
</div>


If you want to learn more about this command use below MS link - https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-rename-transact-sql [https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-rename-transact-sql]

<div>
Thank you so much Pawan, It's working. I also thank you Kevin for the important reminders . More power to you both and God bless!
</div>


Thank you so much Pawan, It's working. I also thank you Kevin for the important reminders . More power to you both and God bless!

<div>
Glad we could help. &nbsp;Take care! &nbsp;Nice job, Pawan!
</div>


Glad we could help.  Take care!  Nice job, Pawan!

<div>
<div class="content wysiwyg-content">
Hi experts, I'm trying to rename one of my tables but the solution below didn't work. When I execute it an error meassage says; &quot;Incorrect syntax near the keyword 'TABLE'.&quot; I'm using Sql 8. Any help please!<br />
<br />
<br />
RENAME TABLE Personnel TO newPersonnel
</div>
</div>


Hi experts, I'm trying to rename one of my tables but the solution below didn't work. When I execute it an error meassage says; "Incorrect syntax near the keyword 'TABLE'." I'm using Sql 8. Any help please!


RENAME TABLE Personnel TO newPersonnel

Rename Table Sql8

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.