Teradata - How to rename a table

rename

table DATABASE_NAME.OLD_TABLE_NAME

to DATABASE_NAME.NEW_TABLE_NAME

;

TSQL - Database stuck in restoring mode

If your database seems to have gotten stuck in "(Restoring...)" mode, then simply run this.

RESTORE DATABASE [DATABASE_NAME_GOES_HERE] WITH RECOVERY;