Schema: [AdventureWorks2016CTP3].[dbo].[Person]

CollapseAll image

Collapse image Schema properties


 Name   Value 
 Name   [Person] 
 Owner   [dbo] 
 ID   6 

Collapse image 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
Total: 23 object(s)

Collapse image 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
Total 23 object(s)

Collapse image Extended properties


Name  Value 
MS_Description Contains objects related to names and addresses of customers, vendors, and employees

Collapse image 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

Collapse image See also


List of schemas