Answer Posted / 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'

How to drop an existing table with "drop table" statements in ms sql server?

1037

---

How to test subquery results with the exists operator?

1036

---

How can I create a report based on a query? : sql server management studio

976

---

Detail about query optimizer?

1037

---

Can a table have 2 foreign keys?

858

---

what is a check constraint?

1040

---

What is attribute? : sql server analysis services, ssas

981

---

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

943

---

SQL Server Architecture ?

2399

---

Can we use where clause with group by?

858

---

What's new in sql management studio for sql server? : sql server management studio

996

---

What is self contained sub query?

973

---

What is the Main Difference between ACCESS and SQL SERVER?

1067

---

How to connect a database with sql express.?

1011

---

what purpose does the model database serve? : Sql server database administration

923

---