Welcome to the Vertica Forum

Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Tips from the Team

Archives for October 2018

Re-Compute a Table Column’s Default Value

Jim_Knicely 841 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 802 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.4K views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Insert Text Into Text

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

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

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

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

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

Jim_Knicely 832 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 823 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Special Date/Time Formatting

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

Jim_Knicely 791 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 893 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 1.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 912 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Displaying the Administration Tools Process ID

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

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

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