How to rename a database in Teradata Database

Database
Highlighted
Ng
Fan

How to rename a database in Teradata Database

And can we rename the system database; and is there a resource which I can refer specifically regarding altering system db and tables?


Accepted Solutions
Ambassador

Re: How to rename a database in Teradata Database

There's no way to rename any database or user.

And there's no way altering system table, too.

1 ACCEPTED SOLUTION
2 REPLIES 2
Teradata Employee

Re: How to rename a database in Teradata Database

Hi Ng,

 

You can't rename a Database in Teradata, aside maybe from specific backup / restore operations.

You have to create a new DB with the new name, then move all objects (again, create them + move the data if tables), check the rights.

Overall it may be a tedious operation for a low-to-none business value outcome.

 

Ambassador

Re: How to rename a database in Teradata Database

There's no way to rename any database or user.

And there's no way altering system table, too.