Forum post
Copy/Duplicate table structure
Forum post posted July 2, 2010 by Gordon Burns, last edited February 9, 2012
2912 Views, 4 Comments
Title:
Copy/Duplicate table structure
Post:
I want to create a new table as a copy of an existing table structure but empty of records.
Using FilemKer Pro 10
Can I do this and how?
Many thanks
Answer
I might be wrong about this but I think that copying of tables can be only achieved using FileMaker Pro Advanced.
If you go to File>>Manage>> Database... in the Tables tab you can Copy and Paste the table which will have no records. Hope this helps.
Probably you can notice the extra buttons [Copy] [Paste] [Import...]
Be the first to like this
|
Sign in to "Like"
Thanks. You may be right. That screen view is not the one I see in FileMaker Pro 10.
All I have is Create, Change or Delete.
What a pain! Why on earth make that an 'advanced' function you have to pay even more for.
Thanks. Guess I'll have to do it the hard way.
Be the first to like this
|
Sign in to "Like"
You can import the table into a new table then delete out the records.
Be the first to like this
|
Sign in to "Like"
Mr_Vodka is correct. When you specify the target table during the import, look to the bottom where it says 'New Database.' BTW, if you open your source table first and Show All Records and then Show Omitted, you will have an empty found set. Leave it open. Then go to your new file and File > Import. When you import by Mr_Vodka's method (and specify new table at bottom from the target popup), you won't have any records but the field names and structure will come over.
Be the first to like this
|
Sign in to "Like"