View sem5.dbo.V_SEM_SVA_COMPUTER_NAME Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
SVA_ID char 32
SEM_SVA.SVA_ID Implied Constraint R
STATUS tinyint 1  √  null
COMPUTER_NAME nvarchar 128  √  null
IP_ADDR1_TEXT varchar 123  √  null

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:


Close relationships: