HELP TABLE columns description

Database
Enthusiast

HELP TABLE columns description

We were using Help Table to get table info and recently started using column 20 instead of column 1 as column 1 only shows max 30 characters.
I am confused so as to whats the difference in "Column Dictionary Name" and "Column SQL Name" and which one to use to always get a full column name. I have seen when using "Column SQL Name" column names comes escaped sometimes. Example if columns name was used "MYCOL" then in the Column SQL Name it comes as "MYCOL" with quotes.

 

Any description available about the columns in the Help Table output?

 

Thanks

1 REPLY 1
Highlighted
Ambassador

Re: HELP TABLE columns description

Not sure about 'where a description is', but...

 

My understanding is that "Column SQL Name" is a value that can always be used in SQL. This is why it is sometimes surrounded by quotes etc.

 

As an example I created the following table:

CREATE TABLE t1
(col1 INTEGER
,"_col2" CHAR(3)
,"2col3" INTEGER
,a234567890b234567890c234567890d234567890e234567890 INTEGER
);

A HELP TABLE command then gives the following output:

Column Name	                Column SQL Name
col1                          	col1
_col2                         	_col2
2col3                         	"2col3"
a234567890b234567890c234567890	a234567890b234567890c234567890d234567890e234567890

HTH

Dave

 

 

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com