Schema: [AdventureWorks2016CTP3].[dbo].[Sales]

CollapseAll image

Collapse image Schema properties


 Name   Value 
 Name   [Sales] 
 Owner   [dbo] 
 ID   9 

Collapse image Objects


Name Type
[Sales].[SalesOrderDetailType_inmem] Datatype
[Sales].[SalesOrderDetailType_ondisk] Datatype
[Sales].[vSalesOrderDetail_extended_inmem] Function
[Sales].[vSalesOrderHeader_extended_inmem] Function
[Sales].[usp_InsertSalesOrder_inmem] Procedure
[Sales].[usp_InsertSalesOrder_ondisk] Procedure
[Sales].[usp_UpdateSalesOrderShipInfo_inmem] Procedure
[Sales].[usp_UpdateSalesOrderShipInfo_native] Procedure
[Sales].[usp_UpdateSalesOrderShipInfo_ondisk] Procedure
[Sales].[CountryRegionCurrency] Table
[Sales].[CreditCard] Table
[Sales].[Currency] Table
[Sales].[CurrencyRate] Table
[Sales].[Customer] Table
[Sales].[CustomerPII] Table
[Sales].[OrderTracking] Table
[Sales].[PersonCreditCard] Table
[Sales].[SalesOrder_json] Table
[Sales].[SalesOrderDetail] Table
[Sales].[SalesOrderDetail_inmem] Table
[Sales].[SalesOrderDetail_ondisk] Table
[Sales].[SalesOrderHeader] Table
[Sales].[SalesOrderHeader_inmem] Table
[Sales].[SalesOrderHeader_ondisk] Table
[Sales].[SalesOrderHeaderSalesReason] Table
[Sales].[SalesPerson] Table
[Sales].[SalesPersonQuotaHistory] Table
[Sales].[SalesReason] Table
[Sales].[SalesTaxRate] Table
[Sales].[SalesTerritory] Table
[Sales].[SalesTerritoryHistory] Table
[Sales].[ShoppingCartItem] Table
[Sales].[SpecialOffer] Table
[Sales].[SpecialOffer_inmem] Table
[Sales].[SpecialOffer_ondisk] Table
[Sales].[SpecialOfferProduct] Table
[Sales].[SpecialOfferProduct_inmem] Table
[Sales].[SpecialOfferProduct_ondisk] Table
[Sales].[Store] Table
[Sales].[TrackingEvent] Table
[Sales].[iduSalesOrderDetail] Trigger
[Sales].[uSalesOrderHeader] Trigger
[Sales].[vIndividualCustomer] View
[Sales].[vPersonDemographics] View
[Sales].[vSalesPerson] View
[Sales].[vSalesPersonSalesByFiscalYears] View
[Sales].[vStoreWithAddresses] View
[Sales].[vStoreWithContacts] View
[Sales].[vStoreWithDemographics] View
[Sales].[StoreSurveySchemaCollection] XML Schema Collection
Total: 50 object(s)

Collapse image Objects that depend on [Sales]


Object name Object type Dep level
[Sales].[usp_InsertSalesOrder_inmem] Procedure 1
[Sales].[usp_InsertSalesOrder_ondisk] Procedure 1
[Sales].[usp_UpdateSalesOrderShipInfo_inmem] Procedure 1
[Sales].[usp_UpdateSalesOrderShipInfo_native] Procedure 1
[Sales].[usp_UpdateSalesOrderShipInfo_ondisk] Procedure 1
[Sales].[CountryRegionCurrency] Table 1
[Sales].[CreditCard] Table 1
[Sales].[Currency] Table 1
[Sales].[CurrencyRate] Table 1
[Sales].[Customer] Table 1
[Sales].[CustomerPII] Table 1
[Sales].[OrderTracking] Table 1
[Sales].[PersonCreditCard] Table 1
[Sales].[SalesOrder_json] Table 1
[Sales].[SalesOrderDetail] Table 1
[Sales].[SalesOrderDetail_inmem] Table 1
[Sales].[SalesOrderDetail_ondisk] Table 1
[Sales].[SalesOrderHeader] Table 1
[Sales].[SalesOrderHeader_inmem] Table 1
[Sales].[SalesOrderHeader_ondisk] Table 1
[Sales].[SalesOrderHeaderSalesReason] Table 1
[Sales].[SalesPerson] Table 1
[Sales].[SalesPersonQuotaHistory] Table 1
[Sales].[SalesReason] Table 1
[Sales].[SalesTaxRate] Table 1
[Sales].[SalesTerritory] Table 1
[Sales].[SalesTerritoryHistory] Table 1
[Sales].[ShoppingCartItem] Table 1
[Sales].[SpecialOffer] Table 1
[Sales].[SpecialOffer_inmem] Table 1
[Sales].[SpecialOffer_ondisk] Table 1
[Sales].[SpecialOfferProduct] Table 1
[Sales].[SpecialOfferProduct_inmem] Table 1
[Sales].[SpecialOfferProduct_ondisk] Table 1
[Sales].[Store] Table 1
[Sales].[TrackingEvent] Table 1
[Sales].[iduSalesOrderDetail] Trigger 1
[Sales].[uSalesOrderHeader] Trigger 1
[Sales].[vSalesOrderDetail_extended_inmem] Function 1
[Sales].[vSalesOrderHeader_extended_inmem] Function 1
[Sales].[SalesOrderDetailType_inmem] Datatype 1
[Sales].[SalesOrderDetailType_ondisk] Datatype 1
[Sales].[vIndividualCustomer] View 1
[Sales].[vPersonDemographics] View 1
[Sales].[vSalesPerson] View 1
[Sales].[vSalesPersonSalesByFiscalYears] View 1
[Sales].[vStoreWithAddresses] View 1
[Sales].[vStoreWithContacts] View 1
[Sales].[vStoreWithDemographics] View 1
[Sales].[StoreSurveySchemaCollection] XML Schema Collection 1
Total 50 object(s)

Collapse image Extended properties


Name  Value 
MS_Description Contains objects related to customers, sales orders, and sales territories.

Collapse image SQL


CREATE SCHEMA [Sales]
    AUTHORIZATION [dbo]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Contains objects related to customers, sales orders, and sales territories.', 'SCHEMA', N'Sales', NULL, NULL, NULL, NULL
GO

Collapse image See also


List of schemas