What's the difference between DELETE TABLE and TRUNCATE TABLE
commands?
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 |
main() { float a=8.8; double b=8.8; if(a==b) printf("Equal"); else printf("not equal"); getch(); } what is the output? with reason
What happens if you free a pointer twice?
Explain why can’t constant values be used to define an array’s initial size?
Write a C program that reads a series of strings and prints only those ending in "ed"
why do we use # in c-language?
DIFFERNCE BETWEEN THE C++ AND C LANGUAGE?
What is a const pointer in c?
int a=20; int b=30; int c=40; printf("%d%d%d"); what will be the output?
How to print "I Love My India" without using semi colon?
What is a ternary operator in c?
In C language what is a 'dangling pointer'?
Meaning of () in c