Export just the base schema

[Malcolm_Jack]

Is there a way to copy a base schema between accounts?

So I don’t need the data - but I’d like to copy the schema (all the tables in a base) to another account. Is there an easy way to do this?

[Alexey_Gusev]

Hi,

Ask other account to grant creator access in his workspace, restore your last base snapshot into it, go to base and delete all records (if needed). I didn’t try but I think, it’s possible.

other way - is to use scripting to get base schema (list of tables/fields) and then create them by script in other place. but there will be a mess with options, and some field types cannot be created by script

[Yves]

Two years later and still no better solution? 😞 

Thank you Alexey for this workaround. Still I would love to see such a feature. It's annoying to do all of this by hand. There should be a template function for new tables.

[Alexey_Gusev]

I think you should better duplicate it with 'Copy records' off.

[Yves]

Unfortunately this does not work cross base / workspace. Or does it?

[Alexey_Gusev]

[Yves]

Thank you. The new base already exists. Any way with existing bases?

EDIT: The best way I came up with, is to sync the table and then stop the sync, but keep the records. Not the best solution since the schema is not 100% correct, but it did the trick for me.

[Alexey_Gusev]

If the base with such name already exists, change Name.
The solution you described works for copy table. You starting the sync then choose "Copy this data into a new table that you can edit" - option designed for copying a table.