Rename table name and column name commands

SQL Server:

EXEC sp_rename ‘oldtablename’, ‘newtablename’;

Oracle:

alter table tablename rename to  newtablename;

MYSQL:

RENAME TABLE table_name TO new_table_name;

POSTGRESQL

ALTER TABLE table_name RENAME TO newtablename;

Rename Column Name

SQL Server:

EXEC sp_RENAME ‘TableName.OldColumnName’ , ‘NewColumnName’, ‘COLUMN’

Oracle:

alter table tablename columname rename to newcolumname

MYSQL:

alter table change oldcoumnname newcoklumnaate

POSTGRESQL

ALTER TABLE table_name RENAME COLUMN column_name TO new_column_name;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.