Additional codes

I remember that BUD once told us how to view all the created tables in our sql account, but I do not remember the command. The command I did write was not the right one - so does anyone remember which entry is needed to retrieve that information?

Also, during our project, we did not know how to alter the name of the actual table as well as altering the names of attributes (columns) after the table has been successfully created.