Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE TABLE
commands?
- 2 Answers
- 5059 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 |
Q.1 write aprogram to stack using linklist o insert 40 items? Q.2 write a program to implement circular queue with help of linklist?
Can a variable be both constant and volatile?
What is c language in simple words?
void main() { for(; 0 ;) ... { printf("hello"); ... } getch(); }
Is fortran still used today?
to get a line of text and count the number of vowels in it
What is difference between main and void main?
sum of two integers values only other then integer it should print invalid input.
What are types of functions?
What is structure padding & expalain wid example what is bit wise structure?
create an SINGLE LINKED LISTS and reverse the data in the lists completely
print the table 5 in loops
C 
