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

Do you know what is sql service broker?

1052

Mention the differences between substr and charindex in sql server.

1023

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1081

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

993

What are indexes in ms sql server?

1035

Can we add an identity column to decimal datatype?

979

How can you stop stored procedures from recompiling?

878

Explain left outer join and right outer join?

1010

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1036

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1021

What is SQL Azure Firewall?

136

How to check if a table is being used in sql server?

942

Explain the advantages of merge replication?

937

What are cursors and when they are useful?

1071

How many databases can we create in a single server?

207