how to alter view to add new identity column to view....

Question

do u know any example that alter the view and add new identity column to the view....

Answer 1

alter table <table name> add column <column name> <data type> after <after what field>

Answer 2

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.