How to change a table name using an SQL query?

Use sp_rename:

EXEC sp_rename 'Stu_Table', 'Stu_Table_10'

You can find documentation on this procedure on MSDN.

If you need to include a schema name, this can only be included in the first parameter (that is, this cannot be used to move a table from one schema to another). So, for example, this is valid:

EXEC sp_rename 'myschema.Stu_Table', 'Stu_Table_10'

In MySQL :-

RENAME TABLE `Stu Table` TO `Stu Table_10`

In MySQL :

RENAME TABLE template_function TO business_function;

ALTER TABLE table_name RENAME TO new_table_name; works in MySQL as well.

Alternatively: RENAME TABLE table_name TO new_table_name;