About SQL Basic Features
Tables are objects in database that hold all the data in a database. In tables, data is logically structured in a column and row format. Each column represents a name of the header or a field in the record and each row represents a unique record.
The DROP TABLE statement is used to drop an existing table in a database. In other words, you can delete any exiting tables in a database. It will delete the definition of table, all the data, indexes, triggers, constraints and permission for that table.
You can not rename any existing table directly in a database. To rename a table, sp_rename is a built-in stored procedure which help us to rename any existing tables in the SQL Server.