Best practice for backing up Teradata Table Structures (DLLs)?

Database

Best practice for backing up Teradata Table Structures (DLLs)?

What is the best practice for backing up all Teradata table structures and view structures?

Can it be done without using a stored procedure or UDF?

Is there an simplier way than submitting the following statements for every for database spaces?

SHOW TABLE databaseName.tableName;

SHOW VIEW databaseName.viewName;

2 REPLIES

Re: Best practice for backing up Teradata Table Structures (DLLs)?

With a Netezza database I run one job and all the tables structures are backup to a file. Does Teradata have anything similar?

Teradata Employee

Re: Best practice for backing up Teradata Table Structures (DLLs)?

Teradata's backup facility performing a dictionary/DBC backup is the appropriate way to back up and be able to restore all structures in the database. It will capture not only the objects but also access rights, logging settings,...