SP_RENAME 'OLDTABLE NAME', 'NEW TABLE NAME' eg: SP

how to rename the table

Question Posted / rajkumar

3 Answers
7454 Views
I also Faced
E-Mail Answers

Answer Posted / rajkumar

SP_RENAME 'OLDTABLE NAME', 'NEW TABLE NAME'
eg:
SP_RENAME 'TBL_EMPLOYEE', 'TBL_EMP'

Is This Answer Correct ?

11 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a virtual table in sql?

1037

What is the difference between the application object and session object?

1123

Can multiple columns be used in sql group by clause in ms sql server?

1118

What are the benefits of filtered indexes?

1095

What is collation?

1195

what are cursors? : Sql server database administration

1105

Can we use having clause without group by?

1031

Explain try...catch with sql server?

1072

What is TDS(Tabular Data Stream) Gateway?

127

how many bits ip address consist of? : Sql server database administration

944

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1117

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

1007

what are the three command line utilities and what are their primary functions?

153

What is tempdb in sql server?

1029

What part does database design plays a role in performance of an sql server-based application?

1035