Which of the following SQL statements is correct?

 Posted by CGN007 on 6/15/2012 | Category: Sql Server Interview questions | Views: 6443 | Points: 40
Select from following answers:
  1. TRUNCATE TABLE student
  2. TRUNCATE * FROM TABLE student
  3. TRUNCATE studentTABLE
  4. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Gemamgall on: 6/27/2012 | Points: 10
TRUNCATE TABLE student is correct statement , as syntax of TRUNCATE is

TRUNCATE TALBE tablename
Posted by: Krishnamsai on: 5/20/2013 | Points: 10

TRUNCATE Table command is used to delete complete data from the existing table.
TRUNCATE TABLE table_name
TRUNCATE TABLE Customers;
customers table is truncated, do the SELECT statement to see the result set. is EMPTY or not.


Posted by: Krishnamsai on: 5/20/2013 | Points: 10

TRUNCATE Table command is used to delete complete data from the existing table.
TRUNCATE TABLE table_name
TRUNCATE TABLE Customers;
customers table is truncated, do the SELECT statement to see the result set. is EMPTY or not.


Login to post response