Schema: [AdventureWorks2016CTP3].[dbo].[Production]

CollapseAll image

Collapse image Schema properties


 Name   Value 
 Name   [Production] 
 Owner   [dbo] 
 ID   7 

Collapse image Objects


Name Type
[Production].[BillOfMaterials] Table
[Production].[Culture] Table
[Production].[Document] Table
[Production].[Illustration] Table
[Production].[Location] Table
[Production].[Product] Table
[Production].[Product_inmem] Table
[Production].[Product_ondisk] Table
[Production].[ProductCategory] Table
[Production].[ProductCostHistory] Table
[Production].[ProductDescription] Table
[Production].[ProductDocument] Table
[Production].[ProductInventory] Table
[Production].[ProductListPriceHistory] Table
[Production].[ProductModel] Table
[Production].[ProductModelIllustration] Table
[Production].[ProductModelProductDescriptionCulture] Table
[Production].[ProductPhoto] Table
[Production].[ProductProductPhoto] Table
[Production].[ProductReview] Table
[Production].[ProductSubcategory] Table
[Production].[ScrapReason] Table
[Production].[TransactionHistory] Table
[Production].[TransactionHistoryArchive] Table
[Production].[UnitMeasure] Table
[Production].[WorkOrder] Table
[Production].[WorkOrderRouting] Table
[Production].[iWorkOrder] Trigger
[Production].[uWorkOrder] Trigger
[Production].[vProductAndDescription] View
[Production].[vProductModelCatalogDescription] View
[Production].[vProductModelInstructions] View
[Production].[ManuInstructionsSchemaCollection] XML Schema Collection
[Production].[ProductDescriptionSchemaCollection] XML Schema Collection
Total: 34 object(s)

Collapse image Objects that depend on [Production]


Object name Object type Dep level
[Production].[BillOfMaterials] Table 1
[Production].[Culture] Table 1
[Production].[Document] Table 1
[Production].[Illustration] Table 1
[Production].[Location] Table 1
[Production].[Product] Table 1
[Production].[Product_inmem] Table 1
[Production].[Product_ondisk] Table 1
[Production].[ProductCategory] Table 1
[Production].[ProductCostHistory] Table 1
[Production].[ProductDescription] Table 1
[Production].[ProductDocument] Table 1
[Production].[ProductInventory] Table 1
[Production].[ProductListPriceHistory] Table 1
[Production].[ProductModel] Table 1
[Production].[ProductModelIllustration] Table 1
[Production].[ProductModelProductDescriptionCulture] Table 1
[Production].[ProductPhoto] Table 1
[Production].[ProductProductPhoto] Table 1
[Production].[ProductReview] Table 1
[Production].[ProductSubcategory] Table 1
[Production].[ScrapReason] Table 1
[Production].[TransactionHistory] Table 1
[Production].[TransactionHistoryArchive] Table 1
[Production].[UnitMeasure] Table 1
[Production].[WorkOrder] Table 1
[Production].[WorkOrderRouting] Table 1
[Production].[iWorkOrder] Trigger 1
[Production].[uWorkOrder] Trigger 1
[Production].[vProductAndDescription] View 1
[Production].[vProductModelCatalogDescription] View 1
[Production].[vProductModelInstructions] View 1
[Production].[ManuInstructionsSchemaCollection] XML Schema Collection 1
[Production].[ProductDescriptionSchemaCollection] XML Schema Collection 1
Total 34 object(s)

Collapse image Extended properties


Name  Value 
MS_Description Contains objects related to products, inventory, and manufacturing.

Collapse image SQL


CREATE SCHEMA [Production]
    AUTHORIZATION [dbo]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Contains objects related to products, inventory, and manufacturing.', 'SCHEMA', N'Production', NULL, NULL, NULL, NULL
GO

Collapse image See also


List of schemas