Sams Teach Yourself SQL in 24 Hours, Second Edition

Q&A

Q1:	When I name a table that I am creating, is it necessary to use a suffix such as_TBL?
A1:	Absolutely not. You do not have to use anything. For example, a table to hold employee information could be named similar to the following, or anything else that would refer to what type of data is to be stored in that particular table: EMPLOYEE EMP_TBL EMPLOYEE_TBL EMPLOYEE_TABLE WORKER
Q2:	Why is it so important to use the schema name when dropping a table?
A2:	Here's a true story about a new DBA that dropped a table: A programmer had created a table under his schema with the same name as a production table. That particular programmer left the company. The programmer's database account was being deleted from the database, but the DROP USER statement ...