Usage of BusinessEntityID

CollapseAll image

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

Collapse image See also


Server index