If creating a table with the same name, then the old table it renamed to XXX$n where "XXX" is the original name and "n" is a version number. You can then access it using this name XXX$n and copy data to the new table with the requested transformation (if the schemas are not the same).
To see all versions of the table use the statement "select * from Metatable".
Please refer to the below samples.
-
XSQL>create table t (x integer);
-
XSQL>select * from Metatable;
-
TableName FieldNo FieldName FieldTypeName FieldType FieldSize AutoGenerated ReferencedTable
-
------------------------------------------------------------------------------
-
t 1 x Int4 6 0 false null
-
Selected records: 1
-
XSQL>create table t (x double);
-
XSQL>select * from Metatable;
-
TableName FieldNo FieldName FieldTypeName FieldType FieldSize AutoGenerated ReferencedTable
-
------------------------------------------------------------------------------
-
t$1 1 x Int4 6 0 false null
-
t 1 x Real8 11 0 false null
-
-
Selected records: 2
-
XSQL>create table t (x int(8), s string);
-
XSQL>select * from Metatable;
-
TableName FieldNo FieldName FieldTypeName FieldType FieldSize AutoGenerated ReferencedTable
-
------------------------------------------------------------------------------
-
t$1 1 x Int4 6 0 false null
-
t$2 1 x Real8 11 0 false null
-
t 1 x Int8 8 0 false null
-
t 2 s String 14 0 false null
-
-
Selected records: 4
阅读(665) | 评论(0) | 转发(0) |
