Generate DDL for a Role in a Teradata Database
There are times I would like to copy the permissions for a role with a Teradata database to use on another database. Below is a nice query to give me … Continue Reading →
Tag: SQL Assistant
Query to Check the Last Time a Teradata View was Rebuilt or Altered
Recently I was asked to update a couple of views on a Teradata database. This script was an easy way to verify that the Teradata views’ timestamp for the DDL … Continue Reading →
Increasing the Font in Teradata SQL Assistant on the Fly
One of my frustrations with the Teradata SQL Assistant is when the application starts, the font in the query window is very small. Recently, I have learned a neat trick … Continue Reading →