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