All fields

[George Stevenson]

How would you go about accessing all of the fields in a database record with
a single statement so that I could copy the record into another database
without needing to know what fields are defined?

I'm interested in backing up database tables from an ODBC source into a
local table without having to reference each individual field in a record.
I want to be able to reference the entire record at once.

 

[Douglas J. Steele]

SELECT * FROM MyTable will return all fields.

 

[George Stevenson]

and can I reference * to move all fields to a different table?

 

[Douglas J. Steele]

INSERT INTO Table2
SELECT * FROM Table1

assuming Table2 has the exact same columns as Table1.

If what you're looking for is a generic ability to do this, there is no
silver bullet. You'll need to ensure that the two databases are set up
consistently.