At 05:11 PM 5/5/2005, you wrote:
Is it possible to project data from one to able to a new table and maintain the structure of the old table.
IE: Index's, Constraints, Auto numbering, ETC
I have a table that has data in it we do not want to loose but is no longer relevant to the table it is in.
Could create a historical record but may need access to it.
Just some rambling thoughts after my initial question.
Steve,
Here's how:
PROJECT newtablename FROM oldtablename USING ALL WHERE COUNT = 0
-- That will create a blank table with EXACT table definition.
PROJECT newtablename FROM oldtablename USING ALL
-- That will create a duplicate table with EXACT table definition.
Have fun!
Very Best R:egards,
Razzak.
