Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

How to rename table in SQL Server?

Anonymous User 2740 16 May 2013

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 Answers

AVADHESH PATEL 16 May 2013

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

advertising

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.