How to add identity column to view?

Do you开发者_StackOverflow know any example of altering a view and add a new identity column?

---

When you see the sp_help of the view, the identity column that is mentioned is nothing but the identity of the underlying table.

If you have already added the identity column in the underlying table, you just need to alter your view and add the identity column in the select stmt.

Else you need to add the identity to your table first and then edit the view to add the column in your select stmt.

---

ALTER TABLE <table name> 
ADD COLUMN <column name> <data type> 
AFTER <after what field>