Sample Corporate Data Model

Transact-SQL Samples

Samples

Sample Corporate Data Model

The corporate data model is a sample database schema published by Silverston, Inmon, and Graziano, and it is licensed for use with Microsoft® SQL Server™ 2000. This sample includes definitions of tables frequently used when implementing models of an enterprise.

For this sample, an additional file called Tabdsc.txt contains detailed table descriptions for the corporate data model.

Default Location

C:\Program Files\Microsoft SQL Server\
80\Tools\Devtools\Samples\Silverstondb\Common

Running the Samples
  1. In SQL Server Enterprise Manager, create a database to store the sample schema elements.

  2. In SQL Query Analyzer, run Common_tables.sql to create the tables, and then run Common_constraints.sql to create primary and foreign key constraints.

  3. In SQL Server Enterprise Manager, open the database you just created to view the contents.

See Also

Database Schema Samples