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

What are the different index configurations a table can have?

1 Answers  

---

Explain the phases a transaction has to undergo?

1 Answers  

---

What about UPDATESTATISTICS ?

2 Answers   HCL, Intelligroup,

---

What is a field in a table?

1 Answers  

---

You are doing log shipping due to some reasons it is failing. How you will proceed from there

1 Answers  

---

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

1 Answers  

---

how can you check the level of fragmentation on a table? : Sql server administration

1 Answers  

---

Which are the olap features?

1 Answers  

---

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1 Answers  

---

how to delete duplicate rows in sql server2005

7 Answers   Cisco, CTS, HCL, IBM,

---

How to populate a table in sql server?

1 Answers  

---

What is the difference between a Application Server and a Database

3 Answers   Oracle,

---