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

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

889

Where views are stored in sql server?

926

How to list all user defined functions in the current database?

977

How to get the number of affected rows?

952

Explain what is the function of sql server agent windows service?

944

What is ms sql server reporting services?

995

What are the elements of dbms?

923

When is the use of update_statistics command?

953

Explain atomicity?

974

What is store procedure? How do they work?

956

How to use group functions in the select clause in ms sql server?

996

What is replication with database mirroring? : sql server database administration

988

Write the queries for commands like Create Table, Delete table, Drop Table etc.

1033

What is the difference between clustered index and primary key?

870

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

988