[SPARK-2189][SQL] Adds unregisterTempTable API

This PR adds an API for unregistering temporary tables. If a temporary table has been cached before, user can unpersist it as well.
Agree with the DDL part.