Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how to rename the table

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

Can sql servers linked to other servers?

1052


What are user defined functions in ms sql server?

1010


What are the different editions available in sql server 2000?

1059


Explain cross join or cartesian product in sql?

896


Working with TLogs

1839


How efficient you are in oracle and SQL server?

1167


Why I am getting "the microsoft .net framework 2.0 in not installed" message?

988


Explain having clause?

972


What are parameterized reports? What are cascading parameters in ssrs reports?

157


What is a with(nolock)?

991


what is a sub-report?

142


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?

2155


Explain what is log shipping?

1148


How to create prepared statements using odbc_prepare()?

1072


Can we do dml on views?

972