Usage of BusinessEntityID
Collapse all
Expand all
BusinessEntityID
Object name
Description
Data type
Length
Parent object type
Type
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Person].[BusinessEntityAddress]
int
4
Table
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Person].[BusinessEntity]
int
4
Table
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Person].[BusinessEntityContact]
int
4
Table
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Person].[EmailAddress]
int
4
Table
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[HumanResources].[Employee_Temporal_History]
int
4
Table
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[HumanResources].[Employee_Temporal]
int
4
Table
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[HumanResources].[Employee]
int
4
Table
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[HumanResources].[EmployeeDepartmentHistory]
int
4
Table
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[HumanResources].[EmployeePayHistory]
int
4
Table
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[HumanResources].[JobCandidate]
int
4
Table
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Person].[Password]
int
4
Table
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Person].[Person_Temporal_History]
int
4
Table
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Person].[Person_Temporal]
int
4
Table
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Person].[Person]
int
4
Table
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[PersonCreditCard]
int
4
Table
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Person].[PersonPhone]
int
4
Table
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Purchasing].[ProductVendor]
int
4
Table
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[SalesPerson]
int
4
Table
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[SalesPersonQuotaHistory]
int
4
Table
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[SalesTerritoryHistory]
int
4
Table
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Person].[sp_DeletePerson_Temporal]
int
4
Procedure
Parameter
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[HumanResources].[sp_UpdateEmployee_Temporal]
int
4
Procedure
Parameter
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Person].[sp_UpdatePerson_Temporal]
int
4
Procedure
Parameter
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[Store]
int
4
Table
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[dbo].[uspGetEmployeeManagers]
int
4
Procedure
Parameter
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[dbo].[uspGetManagerEmployees]
int
4
Procedure
Parameter
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[HumanResources].[uspUpdateEmployeeHireInfo]
int
4
Procedure
Parameter
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[HumanResources].[uspUpdateEmployeeLogin]
int
4
Procedure
Parameter
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[HumanResources].[uspUpdateEmployeePersonalInfo]
int
4
Procedure
Parameter
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Person].[vAdditionalContactInfo]
int
4
View
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[HumanResources].[vEmployee]
int
4
View
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[HumanResources].[vEmployeeDepartment]
int
4
View
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[HumanResources].[vEmployeeDepartmentHistory]
int
4
View
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[HumanResources].[vEmployeePersonTemporalInfo]
int
4
View
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Purchasing].[Vendor]
int
4
Table
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[vIndividualCustomer]
int
4
View
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[HumanResources].[vJobCandidate]
int
4
View
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[vPersonDemographics]
int
4
View
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[vSalesPerson]
int
4
View
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[vStoreWithAddresses]
int
4
View
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[vStoreWithContacts]
int
4
View
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[vStoreWithDemographics]
int
4
View
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Purchasing].[vVendorWithAddresses]
int
4
View
Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Purchasing].[vVendorWithContacts]
int
4
View
Column
Total: 44 objects
See also
Server index