SQL Server Objects in AdventureWorks

The AdventureWorks sample OLTP database contains many SQL Server objects. Additionally, some objects such as common language runtime (CLR) stored procedures are available when the companion samples are installed.

In This Section

Topic Description

Data Types in AdventureWorks

Lists the system and user-defined data types that are used in AdventureWorks, and the tables or samples in which they can be located.

Schemas in AdventureWorks

Describes the schemas that are used in AdventureWorks. Provides details about accessing objects that are contained in the schemas and information about using schema name alternatives.

Stored Procedures in AdventureWorks

Describes the stored procedures that are included in AdventureWorks.

User-defined Functions in AdventureWorks

Describes the user-defined functions that are included in AdventureWorks.

See Also

Other Resources

AdventureWorks Sample OLTP Database
Installing AdventureWorks Sample Databases and Samples

Help and Information

Getting SQL Server 2005 Assistance