/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

2 votes275 views3 answers
Mysql kill
SQL
0 vote246 views1 answer
How to find database collation in postgres
SQL
1 vote243 views1 answer
Sample in sql
SQL
4 votes255 views2 answers
Postgresql reset sequence
SQL
0 vote238 views1 answer
Get duplicate entry sql
SQL
13 votes279 views4 answers
Mysql remove foreign key constraint
SQL
0 vote265 views1 answer
How to run mysql on terminal mac
SQL
0 vote238 views1 answer
Access refused mysql xampp server
SQL
5 votes261 views3 answers
Oracle first day of last year
SQL
0 vote251 views1 answer
Dnsmasq.conf location macos
SQL

Share