What's the difference between DELETE TABLE and TRUNCATE TABLE
commands?
- 2 Answers
- 3723 Views
- CTC, I also Faced
- E-Mail Answers
Answer Posted / naveen reddy
delete table deletes entire table if we want to delete or else we can delete specific column or row.
if we wish to simply get rid of the data but not the table itself? For this, we can use the TRUNCATE TABLE command. The syntax for TRUNCATE TABLE is
TRUNCATE TABLE "table_name"
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between if else and switchstatement
Why is c called a structured programming language?
Why is python slower than c?
What do you know about the use of bit field?
What are dangling pointers? How are dangling pointers different from memory leaks?
On most computers additional memory that is accessed through an adapter of feature card along with a device driver program. a) user memory b) conventional memory c) expandedmemory d) area
What is hash table in c?
Why c is called top down?
What does c value mean?
When c language was developed?
What does int main () mean?
int i[2], j; int *pi;i[0] = 1; i[1] = 5; pi = i; j = *pi + 1 + *(pi + 1)Value of j after execution of the above statements will be a) 7 b) 6 c) 4 d) pointer
How can I write a function that takes a format string and a variable number of arguments?
How can type-insensitive macros be created?
Why do we need functions in c?
