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
0
votes
1answer
48 views

Omit table name and dot in SELECT query

When I perform this query: SELECT `tablename`.* FROM `something`.`tablename` I get a table with column names that contain dots: tablename.c1 | tablename.c2 | tablename.c3 ---------------------------...
0
votes
1answer
27 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
34 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
33 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
142 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
289 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 ...