View: vAdditionalContactInfo

Properties

Property	Value
Name	vAdditionalContactInfo
ID	1787153412
Schema	Person
Owner	dbo
Encrypted
Schema Bound
With Check Option
ANSI NULLS
Uses Quoted Identifier
Has Opaque Metadata
Published
Schema Published
Replicated
Has Replication Filter
Has Unchecked Assembly Data
Date Correlation View
Uses Database Collation
Tracked by CDC
MS Shipped
Modify Date	8/8/2010 5:23:44 PM
Create Date	8/8/2010 5:23:44 PM

Extended Properties

View Columns

Column Name	Datatype	Nullable	Is Identity
BusinessEntityID	int
FirstName	Name
MiddleName	Name
LastName	Name
TelephoneNumber	nvarchar(50)
TelephoneSpecialInstructions	nvarchar(max)
Street	nvarchar(50)
City	nvarchar(50)
StateProvince	nvarchar(50)
PostalCode	nvarchar(50)
CountryRegion	nvarchar(50)
HomeAddressSpecialInstructions	nvarchar(max)
EMailAddress	nvarchar(128)
EMailSpecialInstructions	nvarchar(max)
EMailTelephoneNumber	nvarchar(50)
rowguid	uniqueidentifier
ModifiedDate	datetime

Indexes

Object Level Permissions

Column Level Permissions

Objects that depend on [vAdditionalContactInfo]

• Person.vAdditionalContactInfo

Objects on which [vAdditionalContactInfo] depends

• Person.vAdditionalContactInfo
  • Person.Person
    • dbo.Name
    • dbo.NameStyle
    • Demographics.exist
    • Person.AdditionalContactInfoSchemaCollection
    • Person.BusinessEntity
    • Person.IndividualSurveySchemaCollection

SQL

See also