Appendix B - File Extensions

Extension

Description

Used in

.cdg

Conceptual Data Model

Diagram Editor

.cmp

Data Compare Project

Data Compare

.crp

Custom Report

Report Manager

.ddl

Text File for SQL statements

See the .sql extension.

.dml

Text File for SQL statements

See the .sql extension.

.flt

Data Filter File

SQL Editor, Table Editor, View Editor, Materialized View Editor in the Filter Builder.

.gdk

Database Backup Files

The default extension for an InterBase or Firebird database backup.

.gtp

Grant Template

Grant Manager, holds a selection of privileges for database objects.

.log

Text File for Server Log

InterBase or Firebird server log.

.pdg

Physical Data Model

Diagram Editor

.pmp

Data Pump Project

Data Pump

.sff

Stored Function File

Stored Function Editor

.spf

Stored Procedure File

Stored Procedure Editor

.sql

Text File for SQL statements

SQL Editor, Script Editor, Database Registration Options (Session Recorder) and various other windows where SQL files are used.

.sqp

SQL Pages Files

SQL Editor, Script Editor, editor contents of multiple so-called SQL Pages.

.tdg

Test Data Generator File

Test Data Generator

.trf

Trigger File

Trigger Editor

.txt

Text Files

In various windows, to store text-log files and other text files.