Sql

Search

Rename Table name

- Sql server 
exec sp_rename 'schema.old_table_name', 'new_table_name'

-MySql 
RENAME TABLE `OldTableName` TO `NewTableName`;

--Oracle 
RENAME TABLE OldTableName TO NewTableName;

Comment

Rename table name

ALTER TABLE existing_table_name  
RENAME TO new_name;

Comment

PREVIOUS	NEXT

Code Example
Sql :: mysql select default if null
Sql :: declaring variables in pl sql
Sql :: db.relationship sqlalchemy flask
Sql :: get time component of datetime sql
Sql :: mysql update column to be nullable
Sql :: mysql get last inserted id
Sql :: mysql decimal allow negative values?
Sql :: how to know the character set of an oracle databes
Sql :: mssql dockere
Sql :: stored procedure to delete data from table in mysql
Sql :: sqlite create tables
Sql :: mysql timestamp format
Sql :: mysql remove first and last character from string
Sql :: mysql declare variable
Sql :: run mysql command from bash
Sql :: sql value exists in column
Sql :: sort by mysql
Sql :: grant all privileges microsoft sql
Sql :: mysql order by
Sql :: data formate in sql
Sql :: mysql root permission denied lost
Sql :: oracle dependency
Sql :: check if value is null mysql
Sql :: Query to remove duplicate rows from a table
Sql :: bigquery get last month
Sql :: to_char oracle
Sql :: SQL COUNT() with WHERE
Sql :: sql where part of string match
Sql :: oracle select invalid views
Sql :: mac django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module. Did you install mysqlclient?

Search

SQL

Rename Table name

Rename table name

ADD CONTENT