[User: Saurabh Sharma]

List of Objects which depends on Employee

Server Name DB Name ObjectName Object Type is Ambigious
(0: No , 1: Yes , 2: Error)		 Dependent Object Count Dependent Object Type Dependent Object
CommonDBServer1 AdventureWorks2017 Employee USER_TABLE 0 6 CHECK_CONSTRAINT CK_Employee_BirthDate, CK_Employee_MaritalStatus, CK_Employee_HireDate, CK_Employee_Gender, CK_Employee_VacationHours, CK_Employee_SickLeaveHours
CommonDBServer1 AdventureWorks2017 Employee USER_TABLE 0 5 SQL_STORED_PROCEDURE uspGetEmployeeManagers, uspGetManagerEmployees, uspUpdateEmployeeHireInfo, uspUpdateEmployeeLogin, uspUpdateEmployeePersonalInfo
CommonDBServer1 AdventureWorks2017 Employee USER_TABLE 0 1 SQL_TABLE_VALUED_FUNCTION ufnGetContactInformation
CommonDBServer1 AdventureWorks2017 Employee USER_TABLE 0 1 Constraint/Index (Constraint And Indexes) [Constraint Count: 6]: DF_Employee_SalariedFlag, DF_Employee_VacationHours, DF_Employee_SickLeaveHours, DF_Employee_CurrentFlag, DF_Employee_rowguid, DF_Employee_ModifiedDate |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| Indexes: [Index Count: 6]: PK_Employee_BusinessEntityID, IX_Employee_OrganizationNode, IX_Employee_OrganizationLevel_OrganizationNode, AK_Employee_LoginID, AK_Employee_NationalIDNumber, AK_Employee_rowguid
CommonDBServer1 AdventureWorks2017 Employee USER_TABLE 0 5 VIEW vEmployee, vEmployeeDepartment, vEmployeeDepartmentHistory, vSalesPerson, vSalesPersonSalesByFiscalYears

Employee Depends on following List of Objects

Server Name DB Name ObjectName Object Type is Ambigious
(0: No , 1: Yes , 2: Error)		 Dependent Object Count Dependent Object Type Dependent Object