How to rename table in SQL Server?

Total Post:145

Points:1019
 1665  View(s)
Ratings:
Rate this:
Hi Mindstickians!

I'm working with SQL Server and i'm new in database. I have created few tables in database not a proper naming convention. Now, I want to rename those table with proper naming convention. 

Your help is greatly appreciated.

  1. Post:604

    Points:4228
    Re: How to rename table in SQL Server?

    Hi Ezra!

    Try as following
    Syntax:
    sp_rename 'Your table name' 'New table name'
    Example:
    sp_rename 'MyTable', 'empTable'
    sp_rename this is in-build  stored procedure

      Modified On Mar-30-2018 12:55:42 AM

Answer