15.00 - 15.10 - Teradata Studio - Teradata Database

Teradata Database Introduction to Teradata

Teradata Database
Release Number
Content Type
User Guide
Publication ID
English (United States)
Last Update

Teradata Studio is a client-based GUI used to perform database administration tasks on Teradata Database. Teradata Studio has a modular display that allows users to create a custom user interface. Teradata Studio combines the functionality of Teradata SQL Assistant and Teradata Administrator and allows you to:

  • Search for and view database objects or space and skew
  • Write SQL using content assistance, edit and parse SQL, view history, and use SQL templates and annotations
  • Build and edit SQL requests visually with SQL Query Builder
  • Export result sets to Excel, XML, or text files
  • Generate and run COLLECT STATISTICS requests
  • Load and extract data with a smart data loader that automatically determines data types, creates tables, and loads the data
  • Copy database objects to another database or system
  • Move space between databases
  • Compare SQL DDL side-by-side
  • For more information on the topics presented in this chapter, see the following Teradata Database and Teradata Tools and Utilities books.


    IF you want to learn more about…


    Data Archiving Utilities, including:

  • Archive/Recovery utility
  • Backup and Recovery (BAR), including Backup Application Software products
  • Teradata Archive/Recovery Utility Reference
  • Teradata BAR Solutions Guide
  • Teradata Parallel Transporter

  • Teradata Parallel Transporter User Guide
  • Teradata Parallel Transporter Reference
  • Teradata Parallel Transporter Operator Programmer Guide
  • Teradata Parallel Transporter Application Programming Interface

    Teradata Parallel Transporter Application Programming Interface Programmer Guide

    Standalone Data Load and Export Utilities

  • Teradata FastExport Reference
  • Teradata FastLoad Reference
  • Teradata MultiLoad Reference
  • Teradata Parallel Data Pump Reference
  • Access Modules

    Teradata Tools and Utilities Access Module Programmer Guide

    Basic Teradata Query (BTEQ)

    Basic Teradata Query Reference

    Session and Configuration Management


    System Resource and Workload Management, including:

  • Write Ahead Logging (WAL)
  • Ferret utility
  • Priority Scheduler
  • Teradata Active System Management (ASM)
  • Support Utilities
  • Utilities
  • Database Administration
  • Teradata Workload Analyzer User Guide
  • Teradata SQL Assistant

  • Teradata SQL Assistant for Microsoft Windows User Guide
  • Teradata Developer Exchange http://developer.teradata.com/tools/articles/sql-assistant-java-edition
  • Teradata Studio

    Teradata Studio documentation