title: What is the source column of each column in view
body: <p>How can I know for each column in view, or procedure the source column<br>
  For example,
  I have this table:</p>
  
  <pre><code>CREATE TABLE [dbo].[tbl_Address](
      [iAddressId] [int] IDENTITY(1,1) NOT NULL,
      [nvStreet] [nvarchar](50) NULL,
      [iHouseNum] [int] NULL,
      [nvEnterance] [nvarchar](10) NULL,
      [iFloor] [int] NULL,
      [nvNeighberwood] [nvarchar](20) NULL,
      [nvCity] [nvarchar](20) NULL,
      [nvNote] [nvarchar](50) NULL,
   CONSTRAINT [PK_tbl_Address] PRIMARY KEY CLUSTERED 
  (
      [iAddressId] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  </code></pre>
  
  <p>And this view:</p>
  
  <pre><code>CREATE VIEW ViewALIAS
  AS
  SELECT a.nvStreet myStreet,a.nvCity manyStreeats FROM tbl_Address a  
  </code></pre>
  
  <p>The required answer:  </p>
  
  <pre><code>nameObject | nameColumn | SourceObject | SourceColumn  
  ----------------------------------------------------- 
  tbl_Address| nvStreet   | ViewALIAS    | myStreet  
  tbl_Address| nvCity     | ViewALIAS    | manyStreeats
  </code></pre>
  
  <p>I know how to make the columns: <code>nameObject</code>,  <code>nameColumn</code>, <code>SourceObject</code> 
  or the table: <code>nameObject</code>, <code>SourceObject</code>, <code>SourceColumn</code><br>
  But I do not know how to match x and t </p>