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

Popular posts from this blog

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

web - SVG not rendering properly in Firefox -

java - JavaFX 2 slider labelFormatter not being used -