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 truncate options available in sql server? : sql server database administration

0 Answers  

---

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

0 Answers  

---

How to rebuild the master database?

0 Answers  

---

write sql program to get the detail of student in a class?

2 Answers  

---

How to list all login names on the ms sql server?

0 Answers  

---

select name of emplyoee whose total salary is 130 from following table. id name salary 1 a 100 2 b 20 3 c 50 1 a 30 2 b 70 Post the resulantant Query?

7 Answers  

---

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

0 Answers  

---

What is nonclustered index with included columns ?

0 Answers  

---

Explain DBCC?

0 Answers   QuestPond,

---

Explain the storage models of OLAP?

1 Answers  

---

Which autogrowth database setting is good?

0 Answers  

---

What is ssl in sql server?

0 Answers  

---