Welcome to the Vertica Forum

Tips from the Team

Discussion List

• 
  Re-Compute a Table Column’s Default Value

  Jim_Knicely 844 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
• 
  Derive a Table Column’s Default Value from another Column

  Jim_Knicely 803 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
• 
  Default a Column’s Value

  Jim_Knicely 1.4K views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
• 
  Display View Column Data Types

  Jim_Knicely 1.3K views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
• 
  Insert Text Into Text

  Jim_Knicely 784 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
• 
  Reset Your Session

  Jim_Knicely 806 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
• 
  Conveniently Display Key Projection Info

  Jim_Knicely 782 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
• 
  Checking the Validity of a Table Audit

  Jim_Knicely 994 views 10 comments 1 point Most recent by Sankarmn May 2020Tips from the Team
• 
  Generate an Auto-Incrementing Alphabetical Series Using SQL

  Jim_Knicely 793 views 0 comments 1 point Started by Jim_Knicely October 2018 Tips from the Team
• 
  Viewing Previously Generated Explain Plans

  Jim_Knicely 835 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
• 
  Display Null Query Result With an Alternate Text

  Jim_Knicely 816 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
• 
  Special Date/Time Formatting

  Jim_Knicely 827 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
• 
  Change the VSQL Result Set Border

  Jim_Knicely 793 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
• 
  Find Which System Tables Have a Particular Column Name

  Jim_Knicely 888 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
• 
  Find Which Tables Have a Particular Column Name

  Jim_Knicely 1K views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
• 
  Database Storage - Raw and Compressed Size

  Jim_Knicely 1.1K views 1 comment 1 point Most recent by yalin September 2020Tips from the Team
• 
  Display Last SQL Run Time

  Jim_Knicely 908 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
• 
  Displaying the Administration Tools Process ID

  Jim_Knicely 805 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
• 
  Rotating Column Data Using SQL Analytics

  Jim_Knicely 793 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
• 
  Return Zero Instead of NULL

  Jim_Knicely 957 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team