Database - Introduction to SQL - Discussion
Discussion Forum : Introduction to SQL - General Questions (Q.No. 2)
2.
The command to remove rows from a table 'CUSTOMER' is:
Discussion:
29 comments Page 3 of 3.
Ramya said:
1 decade ago
Delete command is used to delete the particular row in the table. Where as drop command delete entire table.
Pankaj said:
1 decade ago
Puja & ankur are right.
Mirnal said:
1 decade ago
Pooja is right.
Pooja said:
1 decade ago
Delete command delete one row in a table and drop command delete a table.
Sangeeta said:
1 decade ago
I agree with dilip.
Dilip Kumar said:
1 decade ago
Drop table tablename; removes the table from database temporarily whereas drop table tablename purge; command removes the table from database permanently.
This is updated one.
This is updated one.
Kanchana said:
1 decade ago
I go with Ankur command.
Swopna said:
1 decade ago
drop command is used to drop the table entirely.....the table structure will be deleted and update is used to make the changes....delete is used to delete a particular row or column.....i don't know about remove as we haven't used it
Ankur said:
1 decade ago
delete from <table_name> where<condition>;
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers