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

how to rename the table

Question Posted / rajkumar

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

Please Help Members By Posting Answers For Below Questions

What do mean by xml datatype?

1003

What is sql profiler. What are the default templates with it? : sql server database administration

949

How to copy the tables, schema and views from one sql server to another?

985

In case you have filters in your report, when filters will be applied in cached report instance?

103

What are the five characteristics of good data?

865

What is the order in which the sql query is executed?

877

Tell me what is sql profiler?

976

explain different types of constraints? : Sql server database administration

913

Explain the benefits of user-defined functions?

984

Name some of the open source software that you can use in alternative to SSR?

151

Explain system functions or built-in functions? What are different types of system functions?

913

What is sql service broker?

929

What is the difference between a view and a stored procedure?

967

What is a periodical index?

862

What is a raid and what are different types of raid configurations?

1199