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 delete an attribute from the emp table

Answer Posted / sonia

Using the DROP COMMAND-
See the eg below--

create table stup(roll int,name varchar,marks int)
insert into stup values(1,'A',10)
insert into stup values(2,'B',20)
select * from stup
Alter table stup drop column marks
select * from stup

Is This Answer Correct ?    9 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create an multi-statement table-valued function?

1049


What are the export options of ssrs?

178


What is difference between cte and view?

976


Differentiate between mongodb vs. Sql server?

1142


Are null values the same as that of zero or a blank space?

1088


How to connect a database with sql express.?

1118


What is identity?

1081


What is the library index called?

1110


Explain view in sql server?

1091


How can you find out how many rows returned in a cursor?

1086


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

1798


Can an entity have two primary keys?

1030


What is the purpose of indexing?

1090


What protocol does sql server use?

987


What do you mean by authentication modes in sql server?

1135