title: Calling Identity column without inserting any data from source
body: <p>I have a table with Identity column set on ID
  Ex:</p>
  
  <pre><code>Create table Customer
  (
    ID Int identity (1,1),
    FirstName varchar(20),
    PhNumber int,
  )
  </code></pre>
  
  <p>I have a table on other database which populates this table 
  So I wrote something like</p>
  
  <pre><code>Create or alter view abcCustomer 
  As 
  Select 
    ?  as ID
    Fname as FirstName,
    Pnumber as phnumber
  From dbo.Scustomer (this is my table in source)
  </code></pre>
  
  <p>Here we are creating ID column in target only but not sure how to call or what to call from source so that it doesn’t affect the AbcCustomer View and populate identity records in target table and also the FirstName and phNumber from the source table.</p>
  
  <p>Could anyone help what should I write in place of <code>?</code> In order to get my table populated as identity column, because unless and until we call the ID column from the source it’s gonna end up with having errors.</p>