View sem5.dbo.V_SEM_SVA_COMPUTER_NAME | Generated by SchemaSpy |
| |||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Thu Oct 04 16:09 PDT 2012 |
View Definition:
CREATE VIEW V_SEM_SVA_COMPUTER_NAME as SELECT S.SVA_ID, S.STATUS, C.COMPUTER_NAME, C.IP_ADDR1_TEXT FROM SEM_SVA as S with (nolock) LEFT OUTER JOIN V_SEM_SVA_COMPUTER as C WITH (NOLOCK) ON S.COMPUTER_ID = C.COMPUTER_ID WHERE S.DELETED=0
Possibly Referenced Tables/Views:
![]() ![]() |