sybase - How to add two columns to a table -
i have table. want add 2 columns table.
i tried this:
select * dbo.mytable_audit dbo.mytable
but, need 2 colums mytable_audit, how add them in sybase 15-2 ase?
you columns in new table, have in existing one. name, type , order inherited dbo.mytable
. add additional column output, add column select:
select 0 col1, * dbo.mytable_audit dbo.mytable;
this adds column of type integer first column in new table.
Comments
Post a Comment