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'

Tell me what is difference between clustered and non clustered index?

0 Answers  

---

What does the automatic recovery do?

1 Answers  

---

What is difference between unique and primary key?

0 Answers  

---

What do you mean by 'normalization'?

0 Answers   Ernst Young, Thomson Reuters,

---

Do you know what is user defined datatypes and when you should go for them?

0 Answers  

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

0 Answers  

---

How to delete all rows with truncate table statement in ms sql server?

0 Answers  

---

What is referential integrity and how is it achieved?

1 Answers   Adea Solutions,

---

What is page in sql server?

0 Answers  

---

What is #temp and @table variable in SQL server?

0 Answers  

---

What happens if null values are involved in datetime operations?

0 Answers  

---

After removing a table from database, what other related objects have to be dropped explicitly?

0 Answers  

---