Answer / ravikv

SP_Rename 'dbo.table_name.column_name','new column_name'.

Answer / ram&saran

SP_RENAME '<table_name>.<old_column_name>','<new_column_name>'

Answer / praveen kumar.dandu

suppose we had a table name emp and columns ename and sal.

<sql>alter table emp rename column sal to salary;


it wll rename the column sal to salary

How to use subqueries with the in operators in ms sql server?

0 Answers  

---

What are different types of statement?

0 Answers  

---

What do you mean by collation recursive stored procedure?

0 Answers  

---

What is a partitioned view?

0 Answers  

---

What is unique key constraint?

0 Answers  

---

---

What Is Rdbms?

0 Answers   Accenture,

---

How can you check the version of sql server?

0 Answers  

---

what are the advanced features in sql 2008?

2 Answers   Wipro,

---

How to add more data to the testing table in ms sql server?

0 Answers  

---

How to Check Whether a Global Temporary Exists in a SQL Database or not?

2 Answers  

---

How to select all columns of all rows from a table with a select statement in ms sql server?

0 Answers  

---

Explain why variables called the most powerful component of ssis?

0 Answers  

---