SQL COMO ALTERA NOME DE TABELA 1

SQL COMO ALTERA NOME DE TABELA

RENAME TABLE Clientes TO Meus_Clientes;

Here is what the above code is Doing:
1. We’re creating a new table called Meus_Clientes.
2. We’re telling SQLite that the new table will have the same columns as the Clientes table.
3. We’re telling SQLite to copy all the data from the Clientes table into the Meus_Clientes table.
4. We’re telling SQLite to delete the Clientes table.
5. We’re telling SQLite to rename the Meus_Clientes table to Clientes.

Similar Posts