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 |
List at least 10 sorting methods indicating their average case complexity, worst case complexity and best case complexity.
A function 'q' that accepts a pointer to a character as argument and returns a pointer to an array of integer can be declared as: A)int (*q(char*)) [] B)int *q(char*) [] C)int(*q)(char*) [] D)None of the Above
if the area was hit by a virus and so the decrease in the population because of death was x/3 and the migration from other places increased a population by 2x then annually it had so many ppl. find our the population in the starting.
what are two categories of clint-server application development ?
What do you mean by team??
write a c program to print "Welcome" without using semicolon in the whole program ??
What is the difference between ‘g’ and “g” in C?
What is the correct code to have following output in c using nested for loop?
Write a program in C for showing working of different logical operator in C. Your program should guide users with proper message/menu on the console.
What are volatile variables?
WRITE A PROGRAM TO FIND A REVERSE OF TWO NO
How can I convert a number to a string?