database schema


Also found in: Dictionary, Thesaurus, Medical, Legal, Wikipedia.

database schema

The definition of a database. It defines the structure and content in each data element within the structure. Schemas are often designed with visual modeling tools that automatically create the SQL code necessary to define the table structures. See subschema and XML schema.


A Database Schema
In this order processing example, the tables for customers and orders are drawn graphically, and the Erwin modeling program turns the graph into the appropriate SQL code for the target database. (Example courtesy of Logic Works, Inc.)
References in periodicals archive ?
You need to attack problems like this at the source, even if that means, redesigning the production database schema.
How do you shorten the amount of time that it takes to run invoicing when you can't touch either the database schema or the invoicing application?
Due to how the database schema was constructed, early database design decisions were hampering organizational growth.
Embarcadero Schema Manager automates and streamlines the complex and error-prone task of maintaining application database schemas on multiple platforms.
Interactively view the union, intersection and differences between two or more database schemas.
Perform drill-down analysis of the differences between database schemas.
We're excited to now offer the community a chance to experiment with the Database Schema Provider beta and discover the value this tool will bring to Visual Studio Team System 2010.
Download Quest's Database Schema Provider beta: http://teamfuze.
Also, the ability to custom tailor HTML screens with our semantic mapping strategy or support different database schemas is attractive.
DB Copy Expert can be used to copy and migrate schema objects and entire schemas between Oracle databases; copy tables with and without data; copy samples of production data to development or QA environment; copy entire database schemas.
The Zend Query Editor allows developers to execute queries on connected servers, connect live to several servers at once, view database schemas and manage content.