Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


How to delete an attribute from the emp table

Answers were Sorted based on User's Feedback



How to delete an attribute from the emp table..

Answer / 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

How to delete an attribute from the emp table..

Answer / swetha

we can directly ALTER OR DROP the column AND THEN COMMIT ON
IT SO THAT IT GETS MODIFIED

Is This Answer Correct ?    5 Yes 0 No

How to delete an attribute from the emp table..

Answer / amit srivastava

create table stup(roll int,name varchar,marks int)
select * from stup
Alter table stup drop column marks
select * from stup

Is This Answer Correct ?    1 Yes 0 No

How to delete an attribute from the emp table..

Answer / ram murthy

we can delete an attribute through delete command.

Is This Answer Correct ?    1 Yes 8 No

Post New Answer



More SQL Server Interview Questions

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

0 Answers  


How secure is sql server database?

0 Answers  


What is the difference between for xml raw and for xml auto?

0 Answers  


What is dirty read?

0 Answers  


How to verify a login name with sqlcmd tool?

0 Answers  






What is meant by dirty read?

0 Answers  


What does man by sql wildcard characters in sql server?

0 Answers  


explain different types of joins? : Sql server database administration

0 Answers  


What are dml triggers and types of dml triggers?

0 Answers  


what happens on checkpoint? : Sql server database administration

0 Answers  


Please explain what is “asynchronous” communication in sql server service broker?

0 Answers  


SQL Server Performance Tuning for Stored Procedures & reducing debugging time?

1 Answers   CarrizalSoft Technologies,






Categories