What is the difference between a schema and a table and a database?

database schema definition database-table
anbanm picture anbanm · Nov 18, 2008 · Viewed 223.6k times · Source

This is probably a n00blike (or worse) question. But I've always viewed a schema as a table definition in a database. This is wrong or not entirely correct. I don't remember much from my database courses.

Answer

MusiGenesis picture MusiGenesis · Nov 18, 2008

schema : database : table :: floor plan : house : room

Related questions

How do I show the schema of a table in a MySQL database?

From the MySQL console, what command displays the schema of any given table?

Read More
How to create a new schema/new user in Oracle Database 11g?

I have applied for an internship in a company and as a question they have asked me to create a schema for their company with certain requirements and mail them the DDL file. I have installed Oracle database 11g Express …

Read More
Difference Between Schema / Database in MySQL

Is there a difference between a schema and a database in MySQL? In SQL Server, a database is a higher level container in relation to a schema. I read that Create Schema and Create Database do essentially the same thing …

Read More