> > > Can I add any field in my Create view satement.
> > > Example my view is showing data like
> > > Col1 Col2
> > > ----- -----
> > > a 100
> > > b 200
> > > c 300
> > > but I want to show an identity colum like
> > > Col1 Col2 Col3
> > > ---- ----- -----
> > > 1 a 100
> > > 2 b 200
> > > 3 c 300
> > > without selecting any table.
> > > Thanks
> > > Arijit Chatterjee
> > Can't I do any thing with my existing table!!!
> > Please help me out.
> > Arijit Chatterjee
> I want to select my Col2 and Col3 from a table.But the Col1 should be
> generated automatically at the time of creating view..
> Arijit Chatterjee
If you have an identity column that you define as automatically generated,
the value is generated when the row is inserted into the table. This has
nothing to do with a view or when the view is created. To add a column to a
view (which already exists in the table), you need to drop the existing view
and recreate it with the new column (unless you specified select *).
If the identity column is not already defined in the table, you need to
alter the table to add the new column, but it will not populate the column
for existing rows (only when new rows are inserted). To get around this,
unload all the data in the table, drop the table, recreate the table with
new identity column, and then reload the data.
I am not sure if this answers you question, but if not, please clarify.