Schema:
[AdventureWorks2016CTP3].[dbo].[Person]
Name | Value |
Name | [Person] |
Owner | [dbo] |
ID | 6 |
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 |
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 |
Name | Value |
MS_Description | Contains objects related to names and addresses of customers, vendors, and employees |
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 |