Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 2 of 2 total |
Alter table |
Fri, Feb 1 2013 12:03 PM | Permanent Link |
Enrico Lago | Is possible to add a new column with a initial value as an already existing column?
Something like at... alter table MyTable add column if not exists MyColumn Varchar(256) as column AlreadyExistingColumn; |
Fri, Feb 1 2013 1:06 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Enrico
>Is possible to add a new column with a initial value as an already existing column? >Something like at... > >alter table MyTable add column if not exists MyColumn Varchar(256) as column AlreadyExistingColumn; No but you can do it as a script alter table MyTable add column if not exists MyColumn Varchar(256); update MyTable set MyColumn = AlreadyExistingColumn; Roy Lambert [Team Elevate] |
This web page was last updated on Monday, May 6, 2024 at 12:23 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |