Schema:
[AdventureWorks2016CTP3].[dbo].[Purchasing]
Name | Value |
Name | [Purchasing] |
Owner | [dbo] |
ID | 8 |
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 |
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 |
Name | Value |
MS_Description | Contains objects related to vendors and purchase orders. |
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 |