Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • SQL Truncate Table

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 148
    Comment on it

    SQL Truncate Table
    Using this statement you can remove all data of rows or column ( complete data ) not table. In this there is no where clause but where clause is available in Delete statement. Truncate table is faster than Delete statement
    Note -> Drop table query remove the entire structure of a table as well as entire data inside the table but in truncate we can remove the data only not table structure .
    Syntax ->

    Truncate table tablenName ;
    

    Example ->
    Suppose i have a table , name is student and i want to remove the date of student table then we can do like this below ->

    Truncate table student ;
    

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: