Schema: [AdventureWorks2016CTP3].[dbo].[Purchasing]

CollapseAll image

Collapse image Schema properties


 Name   Value 
 Name   [Purchasing] 
 Owner   [dbo] 
 ID   8 

Collapse image Objects


Name Type
[Purchasing].[ProductVendor] Table
[Purchasing].[PurchaseOrderDetail] Table
[Purchasing].[PurchaseOrderHeader] Table
[Purchasing].[ShipMethod] Table
[Purchasing].[Vendor] Table
[Purchasing].[dVendor] Trigger
[Purchasing].[iPurchaseOrderDetail] Trigger
[Purchasing].[uPurchaseOrderDetail] Trigger
[Purchasing].[uPurchaseOrderHeader] Trigger
[Purchasing].[vVendorWithAddresses] View
[Purchasing].[vVendorWithContacts] View
Total: 11 object(s)

Collapse image Objects that depend on [Purchasing]


Object name Object type Dep level
[Purchasing].[ProductVendor] Table 1
[Purchasing].[PurchaseOrderDetail] Table 1
[Purchasing].[PurchaseOrderHeader] Table 1
[Purchasing].[ShipMethod] Table 1
[Purchasing].[Vendor] Table 1
[Purchasing].[dVendor] Trigger 1
[Purchasing].[iPurchaseOrderDetail] Trigger 1
[Purchasing].[uPurchaseOrderDetail] Trigger 1
[Purchasing].[uPurchaseOrderHeader] Trigger 1
[Purchasing].[vVendorWithAddresses] View 1
[Purchasing].[vVendorWithContacts] View 1
Total 11 object(s)

Collapse image Extended properties


Name  Value 
MS_Description Contains objects related to vendors and purchase orders.

Collapse image SQL


CREATE SCHEMA [Purchasing]
    AUTHORIZATION [dbo]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Contains objects related to vendors and purchase orders.', 'SCHEMA', N'Purchasing', NULL, NULL, NULL, NULL
GO

Collapse image See also


List of schemas