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
Can sql servers linked to other servers?
What are user defined functions in ms sql server?
What are the different editions available in sql server 2000?
Explain cross join or cartesian product in sql?
Working with TLogs
How efficient you are in oracle and SQL server?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
Explain having clause?
What are parameterized reports? What are cascading parameters in ssrs reports?
What is a with(nolock)?
what is a sub-report?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
Explain what is log shipping?
How to create prepared statements using odbc_prepare()?
Can we do dml on views?