View: vEmployee

Properties

Property	Value
Name	vEmployee
ID	1803153469
Schema	HumanResources
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
Title	nvarchar(8)
FirstName	Name
MiddleName	Name
LastName	Name
Suffix	nvarchar(10)
JobTitle	nvarchar(50)
PhoneNumber	Phone
PhoneNumberType	Name
EmailAddress	nvarchar(50)
EmailPromotion	int
AddressLine1	nvarchar(60)
AddressLine2	nvarchar(60)
City	nvarchar(30)
StateProvinceName	Name
PostalCode	nvarchar(15)
CountryRegionName	Name
AdditionalContactInfo	xml

Indexes

Object Level Permissions

Permissions for: KrystianRole

Permission	Grantor	Grant	With Grant Option	Deny
Alter
Control
Delete	dbo
Execute
Insert	dbo
Receive
References
Select	dbo
Take Ownership
Update
View Change Tracking
View Definition

Column Level Permissions

Permissions for: JohnBlack

City

Permission	Grantor	Grant	With Grant	Deny
SELECT
REFERENCES
UPDATE	dbo

Title

Permission	Grantor	Grant	With Grant	Deny
SELECT	dbo
REFERENCES
UPDATE

Objects that depend on [vEmployee]

• HumanResources.vEmployee

Objects on which [vEmployee] depends

• HumanResources.vEmployee
  • HumanResources.Employee
    • dbo.Flag
    • Person.Person
      • dbo.Name
      • dbo.NameStyle
      • Demographics.exist
      • Person.AdditionalContactInfoSchemaCollection
      • Person.BusinessEntity
      • Person.IndividualSurveySchemaCollection
  • Person.Address
    • Person.StateProvince
      • Person.CountryRegion
      • Sales.SalesTerritory
  • Person.BusinessEntityAddress
    • Person.AddressType
  • Person.EmailAddress
  • Person.PersonPhone
    • dbo.Phone
    • Person.PhoneNumberType

SQL

See also