Skip to main content
Outputs the DDL statement used to initially create one or more backups accessible via the given data source.
SHOW BACKUP Syntax
The response to SHOW BACKUP is a single-column result set with the DDL statement as the value in the DDL column.

​
Parameters

<backup name>

Name of the backup(s) to show that are accessible via the data source given by data source name.Use <backup name>* to show all backups that start with backup name.Use * instead of <backup name> to show all backups.

<data source name>

Name of the data source to use to retrieve the database backup file information from the remote file store.

​
Examples

For example, to output the DDL for a backup, schema_backup, via a data source, restore_ds, through which the backup files can be accessed:
SHOW BACKUP Example
To output the DDL for all backups whose name starts with conf that are accessible via the restore_ds data source:
SHOW BACKUP (All Backups with Prefix at Data Source) Example
To output the DDL for all backups that are accessible via the restore_ds data source:
SHOW BACKUP (All Backups at Data Source) Example