/SQL/SQL query rename table

SQL query rename table

Rename table sql

ALTER TABLE STUDENTS  
RENAME TO ARTISTS;

19

SQL query rename table

EXEC sp_rename 'old_table_name', 'new_table_name'
Code language: SQL (Structured Query Language) (sql)

1

Source: sqlservertutorial.net

Sql change table name

ALTER TABLE exampletable RENAME TO new_table_name;

0

Source: bluehost.com

Similar codes

0 vote348 views1 answer
Look at running processes redshift
SQL
3 votes299 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
0 vote329 views2 answers
How to count codition
SQL
0 vote311 views1 answer
Get rows from 1 table with other table empty mysql
SQL
0 vote303 views3 answers
Sql all columns
SQL
3 votes314 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
22 votes337 views3 answers
How to join three tables in sql using joins
SQL
40 votes348 views6 answers
Update table mysql
SQL
0 vote321 views4 answers
Sql server date format yyyy-mm-dd
SQL
0 vote302 views1 answer
How to stop all connections to a psql 12 database?
SQL

Share