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 can i change the column name.

Answer Posted / sanjay

ALTER TABLE tablename CHANGE oldname newname varchar (10) ;

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When would you use it?

994


How to modify an existing user defined function?

1106


Can two different columns be merged into single column? Show practically?

1066


Is there any difference between primary key and unique with the not null condition?

949


What is field in algebra?

1038


in the physical file layout, where should the transaction log be stored in relation to the data file?

994


Explain what is analysis service repository?

1000


What security features are available for stored procedure?

1036


how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

907


What is query optimizer in sql server?

1020


Explain contrast amongst grouped and non-bunched records?

1020


You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

1103


When is the use of update_statistics command?

1007


What is an execution plan? When would you use it?

978


how can you check the level of fragmentation on a table? : Sql server administration

982