O'Reilly logo

Teradata Database Administration – The Fundamentals by Thomas Coffing, Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 4 – A DBA's best friend - The Data Dictionary

“My best friend is the one who brings out the best in me!”

- Henry Ford

The Data Dictionary Resides in User DBC

images

The Data Dictionary/Directory is used by the Parsing Engine a lot, but you can see a lot yourself. Just enter the SQL above, and get ready to see what information is captured.

The DBC.DBCInfoV View

images

Use this view to find out what version of Teradata you are on. This is a V13 system.

Querying the Data Dictionary

In real life, we have Grandparents and Parents. In Teradata, we don't ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required