Schema: [AdventureWorks2016CTP3].[dbo].[HumanResources]

CollapseAll image

Collapse image Schema properties


 Name   Value 
 Name   [HumanResources] 
 Owner   [dbo] 
 ID   5 

Collapse image Objects


Name Type
[HumanResources].[sp_GetEmployee_Person_Info_AsOf] Procedure
[HumanResources].[sp_UpdateEmployee_Temporal] Procedure
[HumanResources].[uspUpdateEmployeeHireInfo] Procedure
[HumanResources].[uspUpdateEmployeeLogin] Procedure
[HumanResources].[uspUpdateEmployeePersonalInfo] Procedure
[HumanResources].[Department] Table
[HumanResources].[Employee] Table
[HumanResources].[Employee_Temporal] Table
[HumanResources].[Employee_Temporal_History] Table
[HumanResources].[EmployeeDepartmentHistory] Table
[HumanResources].[EmployeePayHistory] Table
[HumanResources].[JobCandidate] Table
[HumanResources].[Shift] Table
[HumanResources].[dEmployee] Trigger
[HumanResources].[tr_d_AUDIT_Department] Trigger
[HumanResources].[tr_d_AUDIT_Employee] Trigger
[HumanResources].[tr_d_AUDIT_EmployeeDepartmentHistory] Trigger
[HumanResources].[tr_d_AUDIT_EmployeePayHistory] Trigger
[HumanResources].[tr_i_AUDIT_Department] Trigger
[HumanResources].[tr_i_AUDIT_Employee] Trigger
[HumanResources].[tr_i_AUDIT_EmployeeDepartmentHistory] Trigger
[HumanResources].[tr_i_AUDIT_EmployeePayHistory] Trigger
[HumanResources].[tr_u_AUDIT_Department] Trigger
[HumanResources].[tr_u_AUDIT_Employee_Temporal] Trigger
[HumanResources].[tr_u_AUDIT_EmployeeDepartmentHistory] Trigger
[HumanResources].[tr_u_AUDIT_EmployeePayHistory] Trigger
[HumanResources].[vEmployee] View
[HumanResources].[vEmployeeDepartment] View
[HumanResources].[vEmployeeDepartmentHistory] View
[HumanResources].[vEmployeePersonTemporalInfo] View
[HumanResources].[vJobCandidate] View
[HumanResources].[vJobCandidateEducation] View
[HumanResources].[vJobCandidateEmployment] View
[HumanResources].[HRResumeSchemaCollection] XML Schema Collection
Total: 34 object(s)

Collapse image Objects that depend on [HumanResources]


Object name Object type Dep level
[HumanResources].[sp_GetEmployee_Person_Info_AsOf] Procedure 1
[HumanResources].[sp_UpdateEmployee_Temporal] Procedure 1
[HumanResources].[uspUpdateEmployeeHireInfo] Procedure 1
[HumanResources].[uspUpdateEmployeeLogin] Procedure 1
[HumanResources].[uspUpdateEmployeePersonalInfo] Procedure 1
[HumanResources].[Department] Table 1
[HumanResources].[Employee] Table 1
[HumanResources].[Employee_Temporal] Table 1
[HumanResources].[Employee_Temporal_History] Table 1
[HumanResources].[EmployeeDepartmentHistory] Table 1
[HumanResources].[EmployeePayHistory] Table 1
[HumanResources].[JobCandidate] Table 1
[HumanResources].[Shift] Table 1
[HumanResources].[dEmployee] Trigger 1
[HumanResources].[tr_d_AUDIT_Department] Trigger 1
[HumanResources].[tr_d_AUDIT_Employee] Trigger 1
[HumanResources].[tr_d_AUDIT_EmployeeDepartmentHistory] Trigger 1
[HumanResources].[tr_d_AUDIT_EmployeePayHistory] Trigger 1
[HumanResources].[tr_i_AUDIT_Department] Trigger 1
[HumanResources].[tr_i_AUDIT_Employee] Trigger 1
[HumanResources].[tr_i_AUDIT_EmployeeDepartmentHistory] Trigger 1
[HumanResources].[tr_i_AUDIT_EmployeePayHistory] Trigger 1
[HumanResources].[tr_u_AUDIT_Department] Trigger 1
[HumanResources].[tr_u_AUDIT_Employee_Temporal] Trigger 1
[HumanResources].[tr_u_AUDIT_EmployeeDepartmentHistory] Trigger 1
[HumanResources].[tr_u_AUDIT_EmployeePayHistory] Trigger 1
[HumanResources].[vEmployee] View 1
[HumanResources].[vEmployeeDepartment] View 1
[HumanResources].[vEmployeeDepartmentHistory] View 1
[HumanResources].[vEmployeePersonTemporalInfo] View 1
[HumanResources].[vJobCandidate] View 1
[HumanResources].[vJobCandidateEducation] View 1
[HumanResources].[vJobCandidateEmployment] View 1
[HumanResources].[HRResumeSchemaCollection] XML Schema Collection 1
Total 34 object(s)

Collapse image Extended properties


Name  Value 
MS_Description Contains objects related to employees and departments.

Collapse image SQL


CREATE SCHEMA [HumanResources]
    AUTHORIZATION [dbo]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Contains objects related to employees and departments.', 'SCHEMA', N'HumanResources', NULL, NULL, NULL, NULL
GO

Collapse image See also


List of schemas