---
title: "Rename table name and column name using sql query"  
description: "Rename table name and column name using sql query"  
author: "Anonymous User"  
published: 2013-01-05  
updated: 2013-01-05  
canonical: https://www.mindstick.com/forum/529/rename-table-name-and-column-name-using-sql-query  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# Rename table name and column name using sql query

I have a table with the MyTable name and its columns name is \
1. sr\
2. Name\
and i want to [rename](https://www.mindstick.com/interview/23303/how-to-rename-extention-of-mdf-file) MyTable into empTable and Name [column](https://www.mindstick.com/forum/33860/how-to-calculate-column-summary-in-sql-server) rename into empName. \
\
MyTable [structure](https://www.mindstick.com/articles/23258/choose-your-business-structure-wisely) as below\
\
[Create table](https://www.mindstick.com/articles/443/how-to-create-table-in-sql-server) MyTable\
(\
sr int [PRIMARY KEY](https://www.mindstick.com/blog/214/primary-key) [IDENTITY](https://www.mindstick.com/articles/13090/icon-the-identity-of-your-brand),\
Name [varchar](https://www.mindstick.com/forum/161878/what-is-the-difference-between-nvarchar-and-varchar)(100)\
)\
\
can any one help me?\
\
Thank in [advance](https://www.mindstick.com/blog/33258/jee-mains-and-jee-advance-exams)

## Replies

### Reply by AVADHESH PATEL

Hi Ankita Pandey\
\
You can use this code\
I'm renaming your [table](https://www.mindstick.com/articles/43918/how-to-design-table-using-bootstrap) and cloumn name with the storeprocedure sp_Rename\
\
sp_Rename 'MyTable', 'empTable'\
\
Now your table name is empTable after renaming your table and now i am going to rename the Name column into empName.\
sp_Rename 'empTable.Name', 'empName'\
and now you can see your table\
\
Now verify your table\
\
select * from empTable\
\
I hope this resolve your problem


---

Original Source: https://www.mindstick.com/forum/529/rename-table-name-and-column-name-using-sql-query

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.