Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 4 of 4 total |
get and set version of database |
Sat, Oct 20 2012 5:24 AM | Permanent Link |
Torben Laursen | Hi,
How do i read and set the version of the active elevatedb database that I have in use? Regards Torben |
Sat, Oct 20 2012 9:55 AM | Permanent Link |
Fernando Dias Team Elevate | Torben,
Databases don't have a Version attribute. Tables, Views, Procedures and Functions as well as Jobs do have a Version property but not databases. If you need to store version information for your databases you might perhaps use the 'Attributes' or 'Description'. For example: CREATE DATABASE "MyDatabase" PATH 'c:\MyData' ATTRIBUTES 'Version=1.00' or, if you use it only for the version information: CREATE DATABASE "MyDatabase" PATH 'c:\MyData' ATTRIBUTES '1.00' and then retrieve it from the Configuration.Databases table: SELECT Attributes FROM Configuration.databases WHERE Name = 'MyDatabase' - Fernando Dias [Team Elevate] |
Sat, Oct 20 2012 11:19 AM | Permanent Link |
Torben Laursen | I can just set to version on a table if that is directly supported.
how do I set/read the version of a excisting table? Regards Torben |
Sat, Oct 20 2012 11:41 AM | Permanent Link |
Fernando Dias Team Elevate | Torben,
Yes, that is supported, for example: ALTER TABLE MyTable VERSION 2.00 CREATE TABLE MyTable ("OneColumn" INTEGER) VERSION 1.00 You can then read it from the Information.Tables table : SELECT Version FROM Information.Tables WHERE Name = 'MyTable' ; -- Fernando Dias [Team Elevate] |
This web page was last updated on Tuesday, May 7, 2024 at 06:25 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |