Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE TABLE
commands?
- 2 Answers
- 5094 Views
- CTC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kalyan
truncate table means structure of table cannot deleted but
it deletes the data in the table. And Delete command deletes
the entire table with data.
| Is This Answer Correct ? | 1 Yes | 0 No |
c language interview questions & answer
What are unions in c?
what is the difference between strcpy() and memcpy() function?
What is c value paradox explain?
Taking an example,differentiate b/w loader and linker ?
State two uses of pointers in C?
Why is void main used?
declare afunction pointer to int printf(char *)?
Tell us the difference between these two : #include"stdio.h" #include<stdio.h> define in detial.
when i declare as: void main() { clrscr(); int a=10; printf("%d",a) } my problem that why generate a error in above programs. please tell me answer seriously .
how can write all 1to 100 prime numbers using for loop,if and break ?
What are called c variables?
C 
