SQL Schema

An SQL Schema represents the structure of an SQL database including its tables and their associated columns, keys, relations, indexes, metadata (such as character encoding and storage mode) and potentially other platform-agnostic or vendor-specific data characteristics such as Stored Procedures, Triggers and ORM code-generation mappings.

Tools

• SchemaSpy: http://schemaspy.org/ | DOCS | SRC

Resources

• SQL Schema: http://www.sql.org/sql-database/postgresql/manual/ddl-schemas.html
• SQL (required) data types: http://www.w3schools.com/sql/sql_datatypes.asp (common to all SQL database servers)
• SQL (common) data types: http://www.w3schools.com/sql/sql_datatypes_general.asp (common to most, some variation)

EXAMPLES

• Example Database Schemas - Data Models: http://www.databaseanswers.org/data_models/ (diagrams only)
• Wikipedia's DB schema diagram: http://upload.wikimedia.org/wikipedia/commons/3/36/Mediawiki_database_Schema.svg
• MySQL - sample schema: http://dev.mysql.com/doc/sakila/en/ (Sakila company/employee)
• Oracle - sample schema: http://docs.oracle.com/cd/B28359_01/server.111/b28328/scripts.htm (generic HR dept)
• IBM DB2 - sample schema: http://www-03.ibm.com/systems/i/software/db2/sqldata.html | PL/SQL example | DDL example (company/dept)
• MS-Access - sample schema: http://northwinddatabase.codeplex.com/ (Northwind)

Tutorials

• What is a DB Schema?: http://www.quackit.com/sql_server/sql_server_2008/tutorial/sql_server_database_schemas.cfm
• What are the difference between DDL, DML and DCL commands?: http://www.orafaq.com/faq/what_are_the_difference_between_ddl_dml_and_dcl_commands
• Import and Export a Database with SSH: http://architects.dzone.com/articles/import-and-export-database-ssh
• Implementing SchemaSpy in your MySQL environment: https://www.percona.com/blog/2013/06/04/implementing-schemaspy-in-your-mysql-environment/

External Links

• wikipedia: Database schema
• wikipedia: SQL:2003 (first SQL spec to formally define DDL standard)
• wikipedia: Data dictionary
• wikipedia: Data definition language

See Also

SQL | Schema