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

  • How to Rename Table Name in SQL Database

    @mukesh.tomar
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 191
    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
    SQL Tables sql rename
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           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: