Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • How to Rename Table Name in SQL Database

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 193
    Comment on it

    SQL rename statement is used to change the name of the table in database . Sometime we want to change our table name i.e we want to give some useful name of our table . SO by using this statement we can do the same .
    Syntax

    Rename oldTableName to NewTableName ;
    

    Suppose i have a table , name is student

    **Student name**        **Student Age**             **Student Id**
        Mukesh                      23                          1
        Ayush                       24                          2
    

    I want to rename this table name , see below

    rename student to studentInfo ; // after executed this statement student table name will changed to studentInfo 
    

 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: