Schema:
[AdventureWorks2016CTP3].[dbo].[Person]
Schema properties
| Name | Value |
| Name | [Person] |
| Owner | [dbo] |
| ID | 6 |
Objects
| Name | Type |
| [Person].[sp_DeletePerson_Temporal] | Procedure |
| [Person].[sp_UpdatePerson_Temporal] | Procedure |
| [Person].[Address] | Table |
| [Person].[AddressType] | Table |
| [Person].[BusinessEntity] | Table |
| [Person].[BusinessEntityAddress] | Table |
| [Person].[BusinessEntityContact] | Table |
| [Person].[ContactType] | Table |
| [Person].[CountryRegion] | Table |
| [Person].[EmailAddress] | Table |
| [Person].[Password] | Table |
| [Person].[Person] | Table |
| [Person].[Person_json] | Table |
| [Person].[Person_Temporal] | Table |
| [Person].[Person_Temporal_History] | Table |
| [Person].[PersonPhone] | Table |
| [Person].[PhoneNumberType] | Table |
| [Person].[StateProvince] | Table |
| [Person].[iuPerson] | Trigger |
| [Person].[vAdditionalContactInfo] | View |
| [Person].[vStateProvinceCountryRegion] | View |
| [Person].[AdditionalContactInfoSchemaCollection] | XML Schema Collection |
| [Person].[IndividualSurveySchemaCollection] | XML Schema Collection |
Objects that depend on [Person]
| Object name | Object type | Dep level |
| [Person].[sp_DeletePerson_Temporal] | Procedure | 1 |
| [Person].[sp_UpdatePerson_Temporal] | Procedure | 1 |
| [Person].[Address] | Table | 1 |
| [Person].[AddressType] | Table | 1 |
| [Person].[BusinessEntity] | Table | 1 |
| [Person].[BusinessEntityAddress] | Table | 1 |
| [Person].[BusinessEntityContact] | Table | 1 |
| [Person].[ContactType] | Table | 1 |
| [Person].[CountryRegion] | Table | 1 |
| [Person].[EmailAddress] | Table | 1 |
| [Person].[Password] | Table | 1 |
| [Person].[Person] | Table | 1 |
| [Person].[Person_json] | Table | 1 |
| [Person].[Person_Temporal] | Table | 1 |
| [Person].[Person_Temporal_History] | Table | 1 |
| [Person].[PersonPhone] | Table | 1 |
| [Person].[PhoneNumberType] | Table | 1 |
| [Person].[StateProvince] | Table | 1 |
| [Person].[iuPerson] | Trigger | 1 |
| [Person].[vAdditionalContactInfo] | View | 1 |
| [Person].[vStateProvinceCountryRegion] | View | 1 |
| [Person].[AdditionalContactInfoSchemaCollection] | XML Schema Collection | 1 |
| [Person].[IndividualSurveySchemaCollection] | XML Schema Collection | 1 |
Extended properties
| Name | Value |
| MS_Description | Contains objects related to names and addresses of customers, vendors, and employees |
SQL
CREATE SCHEMA [Person] AUTHORIZATION [dbo] GO EXEC sp_addextendedproperty N'MS_Description', N'Contains objects related to names and addresses of customers, vendors, and employees', 'SCHEMA', N'Person', NULL, NULL, NULL, NULL GO |
See also