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 2 of 3.
Hitendra Dineshbhai Pansuriya said:
1 decade ago
Delete is used for row data hence it will be use and after is to change structure of table like add and drop or column and index.
Hitendra Dineshbhai Pansuriya said:
1 decade ago
After is used to change data in row and update is used to change structure of table like add and drop of column and index's.
Kawaljeet said:
1 decade ago
The command DELETE delete the rows from a table and by a condition where clause,you can delete a particular row.
Ramya said:
1 decade ago
Delete command is used to delete the particular row in the table. Where as drop command delete entire table.
K.V.L.K.Prasanna Kumar said:
1 decade ago
We should not use the where clause if we want to delete all the rows and it should end with ; .
Kanimozhi said:
9 years ago
To remove rows from table: DELETE FROM "table_name" where "condition";.
(1)
Pooja said:
1 decade ago
Delete command delete one row in a table and drop command delete a table.
Mounika Pallapu said:
10 years ago
DELETE is used for delete one or more than one records but not table.
(1)
Hitendra Dineshbhai Pansuriya said:
1 decade ago
Delete is used to delete row and drop is used delete whole table.
Harsha said:
10 years ago
DELETE FROM <Table_Name> WHERE <Col_Name> IS NULL;
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers