RENAME Command

Changes the name of a file to a new name.

NoteNote

Do not use RENAME to change the name of a table in a database; RENAME does not change the name of the table in the database. Instead, use RENAME TABLE to change the name of a table in a database. For more information, see RENAME TABLE Command.

RENAME FileName1 TO FileName2

Parameters

FileName1 TO FileName2

Specifies the file name to change and the new file name. Include a file extension for each file.

NoteNote

If the file extensions are not included, the default extension .dbf is assumed. To rename a file that does not have an extension, include a period (.) after the file name. If you rename a free table that has an associated .fpt memo file, be sure to rename the memo file.

Expand imageRemarks

Expand imageExample

Expand imageSee Also


© , 1996-2020 • Updated: 11/10/20
Comment or report problem with topic