-2

What is the difference between schema and database? I have no knowledge other than running basic commands in sql such as select, update, insert and delete.

Wtower
  • 18,848
  • 11
  • 103
  • 80
muthu
  • 79
  • 2
  • 6
  • 4
    Possible duplicate of [Difference between database and schema](http://stackoverflow.com/questions/5323740/difference-between-database-and-schema) – Joff Jul 30 '16 at 05:51
  • i don't know what is the basics itself there it has been discussed about the difference only – muthu Jul 30 '16 at 05:59
  • 1
    Either that provided link, or a Google search. This doesn't warrant yet another question. – Jamal Jul 30 '16 at 06:25
  • There is no such thing called "database" in the SQL standard. The namespace "above" a schema is called a "catalog". –  Mar 04 '17 at 07:19

1 Answers1

0

A Database is a collection of organized data, while database schema describes the structure and organization of data in a database system. The database holds the records, fields and cells of data. The database schema describes how these fields and cells are structured and organized and what types of relationships are mapped between these entities. Understandably, the schema of a database keeps constant once created, while the actual data in the database tables may change all the time.

Alfaiz Ahmed
  • 1,698
  • 1
  • 11
  • 17
  • so what i understand from your answer is database is collection of data (what are the data's i save ) where as schema say how to store the data / – muthu Jul 30 '16 at 06:19
  • The term "schema" refers to the organization of data as a blueprint of how the database is constructed (divided into database tables in the case of relational databases). – Alfaiz Ahmed Jul 30 '16 at 06:31
  • The term schema also refers to a namespace that groups objects together –  Mar 04 '17 at 07:20