Search code examples
databasesql-server-2008datatabletable-rename

Change A Database's Table's Name (SQL Server 2008)


I got a table named tblHello and I wanna rename it to Hello


Solution

  • Right click on the table and select rename in management studio You can also use sp_rename:

    sp_rename 'old_table_name', 'new_table_name'