And can we rename the system database; and is there a resource which I can refer specifically regarding altering system db and tables?
Solved! Go to Solution.
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.