Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE TABLE
commands?
- 2 Answers
- 4914 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
A routine usually part of the operation system that loads a program into memory prior to execution a) linker b) loader c) preprocessor d) compiler
What is the basic structure of c?
`write a program to display the recomended action depends on a color of trafic light using nested if statments
What is the difference between fread and fwrite function?
Why C language is a procedural language?
What are pointers? What are stacks and queues?
Why does this code crash?
How would you rename a function in C?
Explain what is the benefit of using const for declaring constants?
hi any body pls give me company name interview conduct "c" language only
what is the difference between north western polytechnique university and your applied colleges?? please give ur answers for this. :)
What are the advantages of union?
What is the use of in c?
C program to find all possible outcomes of a dice?
What is the difference between %d and %i?
