Questions tagged [rename]

This tag is for renaming database, DBMS instances and database objects (such as tables, views, columns, etc.)

Filter by
Sorted by
Tagged with
4
votes
2answers
252 views

How can I safely rename a sequence in PostgreSQL, ideally without downtime?

We want to rename some sequences in our production database for certain reasons. Is there a way to do this safely in production without having to first close all connections to the database? It's ...
0
votes
1answer
85 views

Renaming multiple databases on a MySQL slave

I have 4 mysql databases that I'm replicating from a master to a slave. In the past, I have renamed one of them because the slave is also a dev server where it has a dev version of that schema with ...
0
votes
0answers
94 views

How to rename parent table and child tables in partition tables postgres 9.6

I am trying to rename parent table in partitions. I created 45 child tables on monthly wise manner. I can alter the name of parent table but I don't know how to alter the 45 child table references. ...
0
votes
0answers
34 views

renaming Windows machine and SQL Server

We've built a new Windows 2016 VM with SQL Server 2016 that we'll migrate a mission critical database currently on SQL Server 2008 R2 to. The original plan was to have users test, test, test and test ...
1
vote
0answers
207 views

Rename table in Postgres and update its usages in all functions

I need to safely rename a table and be sure, that all usages of this table in functions are also renamed. Example: CREATE TABLE test ( id serial, name varchar(255) ); CREATE FUNCTION public....
1
vote
1answer
337 views

SQL Server and TFS - How to rename stored procedures

After a while one may wish to do some light refactoring, such as giving more appropriate names to stored procedures as their functionalities are better established. For the life of me, I simply ...