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 1 of 3.
Rakesh dasari said:
1 decade ago
Update used only to make changes in existing records, reamainin options are used to do operations on the table not individual columns.
Ankur said:
1 decade ago
delete from <table_name> where<condition>;
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
Kanchana said:
1 decade ago
I go with Ankur command.
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.
Sangeeta said:
1 decade ago
I agree with dilip.
Pooja said:
1 decade ago
Delete command delete one row in a table and drop command delete a table.
Mirnal said:
1 decade ago
Pooja is right.
Pankaj said:
1 decade ago
Puja & ankur are right.
Ramya said:
1 decade ago
Delete command is used to delete the particular row in the table. Where as drop command delete entire table.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers