schema icon Schema: Person

Properties

Name Value
Name Person
ID 6
Owner dbo

Extended Properties

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

Permissions

No object level permissions defined.

Objects

Name Type
CK_Person_EmailPromotion CHECK constraint
CK_Person_PersonType CHECK constraint
FK_Address_StateProvince_StateProvinceID FOREIGN KEY constraint
FK_BusinessEntityAddress_Address_AddressID FOREIGN KEY constraint
FK_BusinessEntityAddress_AddressType_AddressTypeID FOREIGN KEY constraint
FK_BusinessEntityAddress_BusinessEntity_BusinessEntityID FOREIGN KEY constraint
FK_BusinessEntityContact_BusinessEntity_BusinessEntityID FOREIGN KEY constraint
FK_BusinessEntityContact_ContactType_ContactTypeID FOREIGN KEY constraint
FK_BusinessEntityContact_Person_PersonID FOREIGN KEY constraint
FK_EmailAddress_Person_BusinessEntityID FOREIGN KEY constraint
FK_Password_Person_BusinessEntityID FOREIGN KEY constraint
FK_Person_BusinessEntity_BusinessEntityID FOREIGN KEY constraint
FK_PersonPhone_Person_BusinessEntityID FOREIGN KEY constraint
FK_PersonPhone_PhoneNumberType_PhoneNumberTypeID FOREIGN KEY constraint
FK_StateProvince_CountryRegion_CountryRegionCode FOREIGN KEY constraint
FK_StateProvince_SalesTerritory_TerritoryID FOREIGN KEY constraint
PK_Address_AddressID PRIMARY KEY constraint
PK_AddressType_AddressTypeID PRIMARY KEY constraint
PK_BusinessEntity_BusinessEntityID PRIMARY KEY constraint
PK_BusinessEntityAddress_BusinessEntityID_AddressID_AddressTypeID PRIMARY KEY constraint
PK_BusinessEntityContact_BusinessEntityID_PersonID_ContactTypeID PRIMARY KEY constraint
PK_ContactType_ContactTypeID PRIMARY KEY constraint
PK_CountryRegion_CountryRegionCode PRIMARY KEY constraint
PK_EmailAddress_BusinessEntityID_EmailAddressID PRIMARY KEY constraint
PK_Password_BusinessEntityID PRIMARY KEY constraint
PK_Person_BusinessEntityID PRIMARY KEY constraint
PK_PersonPhone_BusinessEntityID_PhoneNumber_PhoneNumberTypeID PRIMARY KEY constraint
PK_PhoneNumberType_PhoneNumberTypeID PRIMARY KEY constraint
PK_StateProvince_StateProvinceID PRIMARY KEY constraint
iuPerson SQL DML trigger
functionSynonym Synonym
otherDB Synonym
Address Table (user-defined)
AddressType Table (user-defined)
BusinessEntity Table (user-defined)
BusinessEntityAddress Table (user-defined)
BusinessEntityContact Table (user-defined)
ContactType Table (user-defined)
CountryRegion Table (user-defined)
EmailAddress Table (user-defined)
Password Table (user-defined)
Person Table (user-defined)
PersonPhone Table (user-defined)
PhoneNumberType Table (user-defined)
StateProvince Table (user-defined)
vAdditionalContactInfo View
vStateProvinceCountryRegion View
AdditionalContactInfoSchemaCollection XML Schema Collection
IndividualSurveySchemaCollection XML Schema Collection

SQL

Script
CREATE SCHEMA [Person] AUTHORIZATION [dbo]
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Contains objects related to names and addresses of customers, vendors, and employees. mobi update' , @level0type=N'SCHEMA',@level0name=N'Person'

See also

List of Schemas