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.
Shik said:
4 years ago
Truncate -- if we truncate a table, the structure of the table remains same and the data inside the table will be deleted.
BUT IN, Delete --- whole table or particular row is deleted. Here the structure of the table is also deleted.
BUT IN, Delete --- whole table or particular row is deleted. Here the structure of the table is also deleted.
Rithy said:
6 years ago
What is the difference between truncate and delete command? Because both commands are used to delete rows in a table. Which one is preferable?
Thanks in advance!
Thanks in advance!
Kanimozhi said:
6 years ago
To remove rows from table: DELETE FROM "table_name" where "condition";.
Mounika Pallapu said:
7 years ago
DELETE is used for delete one or more than one records but not table.
Harsha said:
8 years ago
DELETE FROM <Table_Name> WHERE <Col_Name> IS NULL;
Harsha said:
8 years ago
This statement is used to delete records in a table.
By using where statement we can specify which regard to be deleted. Or else whole will be deleted.
By using where statement we can specify which regard to be deleted. Or else whole will be deleted.
Vijju said:
8 years ago
How can we delete null values or a row from a table?
Hitendra Dineshbhai Pansuriya said:
8 years 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.
Hitendra Dineshbhai Pansuriya said:
8 years ago
Delete is used to delete row and drop is used delete whole table.
Hitendra Dineshbhai Pansuriya said:
8 years 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.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers