Managing tables

Actions such as copying, moving, deleting, and importing tables produce different results depending on the table types involved.

Copying tables

When you copy a standalone or master table, you can:

• Paste create a new standalone table and source data file
• Paste Link create a new linked table

If a copy and overwrite operation involves tables that both have source data files in AX Server, the overwritten table’s data file is overwritten along with the layout.

For steps and additional information, see the following:

• Managing folder items
• Table copy combinations
• Table copy and overwrite combinations

Moving tables

When you move a table in AX Server, the result depends on the table type you are moving. If the table has a source data file, the moved tables maintains a dynamic association with the underlying file. When you move shared tables, a copy of the original data file is created for each moved table.

If a move and overwrite operation involves tables that both have source data files in AX Server, the overwritten table’s data file is overwritten along with the layout.

For steps and additional information, see the following:

• Managing folder items
• Table move combinations
• Table move and overwrite combinations

Importing tables

When you import a table, the result depends on the type of table you import and whether or not you select Import source data files:

• local table the source data file is imported with the table layout
• server table has no effect as the source data file is already on AX Server
• local shared tables continue to share the same data file on AX Server
• server shared tables imported tables become standalone with a separate copy of the source data file

For steps and additional information, see the following:

• Import a folder item
• Table import combinations
• Table import and overwrite combinations

Deleting tables

Depending on the table type, deleting the table has different implications for the underlying source data file:

• standalone deletes the associated source data file
• master deletes the associated source data file
• shared does not delete the source data file unless it is the last shared table, or you delete all shared tables associated with a source data file simultaneously
• linked does not delete the source data file
• layout no source data file

For steps on deleting tables, see Managing folder items.