Skip to content
  • View menu
  • View sidebar

Field Effect, LLC

  • Access SQL Editor
    • Buy Now!
    • Free Trial!
    • Downloads
    • Documentation
  • Product Support
  • Tech Recipes
    • VBA
    • Teradata
    • DB2
    • Linux
    • Android
    • Windows Server
    • VMWare ESXi
    • MS Office
  • Virtual USB Keyboard Project

Shopping Cart

Number of items in cart: 0

  • Your cart is empty.
  • Total: $0.00
  • Checkout

Recent Posts

  • C#: Quickly Propagating Properties of an Object to the Parent Class
  • Fix for applications that do not support high DPI
  • A Development SMTP Server for Testing
  • Debian Root Drive on an F2FS Filesystem
  • Generating a .NET DLL for use with VBA

Archives

  • December 2019
  • March 2018
  • April 2016
  • March 2016
  • August 2015
  • March 2015

Teradata Recipes

Contents

  • 1 Get all databases in the Teradata system
  • 2 Get all tables in a particular database
  • 3 List all fields in a table

Get all databases in the Teradata system

SELECT * FROM DBC.Databases

Get all tables in a particular database

SELECT * FROM DBC.Tables WHERE DatabaseName='DbName'

List all fields in a table

HELP TABLE TableName

OR

SELECT * FROM DBC.Columns [WHERE TableName Like '%TblName%'] [AND ColumnName Like '%ColName%']

 

Contact Us: Field Effect, LLC | 25 Cambridge Dr. | North Caldwell, NJ (USA) 07006 | +1 973-932-0199 | [email protected]
Privacy Policy | Refund Policy