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'

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

0 Answers  

---

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,

---

What is the difference between lock, block and deadlock? : sql server database administration

0 Answers  

---

What is the advantage of sql server?

0 Answers  

---

What do you understand by hotfixes and patches in sql server?

0 Answers  

---

optimization techinques

0 Answers   Wipro,

---

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

0 Answers  

---

Can we call future method from trigger?

0 Answers  

---

How to execute function in stored procedure sql server?

0 Answers  

---

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

0 Answers  

---

Explain go command in sql server?

0 Answers  

---

Can you explain the disadvantages/limitation of the cursor?

0 Answers  

---