What is the difference between database and table?
A table is an object inside a database. A database has tables of
data, views, indexes and programs. A database can have 10 or
thousands of tables.
More specifically, a table is a collection (rows) of data on a
single related topic. For example, the Employees table would have
employee data, each row being a different employee, but it would
not have Inventory data. That would be in the Inventory table.
A database is a collection of objects, primarily tables, but
also indexes to help search the tables, views that filter, select
and combine the data in the tables, and stored procedures
(pre-defined programs that perform specific actions on the
database).