Answer / rajkumar

SP_RENAME 'OLDTABLE NAME', 'NEW TABLE NAME'
eg:
SP_RENAME 'TBL_EMPLOYEE', 'TBL_EMP'

Answer / vishal

Rename a table using sp_rename

sp_rename <Old Table Name>, <New Column Name>


Rename a column using sp_rename
here as third argument we have to provide column. default
third argument for sp_rename is table.


sp_rename <table name>.<old Column Name>, <New Column Name>,
'column'

Answer / mohan

Rename a table
This example renames the customers table to custs.

EXEC sp_rename 'customers', 'custs'

B. Rename a column
This example renames the contact title column in the
customers table to title.

EXEC sp_rename 'customers.contacttitle', 'title', 'COLUMN'

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

0 Answers  

---

Do you know hot add cpu in sql server 2008?

0 Answers  

---

What is meant by indexing?

0 Answers  

---

What are “phantom rows”?

0 Answers  

---

List some of the rules that apply to creating and using a ‘view’

0 Answers  

---

What is row_number function?

0 Answers  

---

what stored procedure can you use to display the current processes? : Sql server administration

0 Answers  

---

Can we call stored procedure in trigger?

0 Answers  

---

What's the difference between DELETE TABLE and TRUNCATE TABLE commands?

9 Answers  

---

What authentication modes does sql server support?

0 Answers  

---

what is the Ticketing tool used in Wipro technologies at Bangalore...???

0 Answers   Liquid Hub,

---

What are difference between Cluster index and Non-Cluster index?

0 Answers   QuestPond,

---