Add title to view column

General

Add title to view column

Hi

Try to find some info about how to add info into a Title attribute for a View Column... No luck...

I can stuff Comment into all objects, and Titles into table columns, but view columns... no  !

Is it against some nature of the TD database ?

Any hints ?

Regards

/T

Tags (3)
2 REPLIES
Enthusiast

Re: Add title to view column

Thorkil,

You can list the columnnames you want first.

REPLACE VIEW dbname.viewname (Columnnameyouwant)

AS Lock Row for access SELECT columnnameyouhave FROM dbname.tbname

Rglass

Junior Contributor

Re: Add title to view column

You can add a title, but it's not shown in dbc.ColumnsV or HELP TABLE:

REPLACE VIEW testview AS
SELECT InfoKey (TITLE 'bla') FROM dbc.dbcInfoV WHERE InfoKey = 'VERSION';

*** View has been replaced.
*** Total elapsed time was 1 second.

BTEQ -- Enter your SQL request or BTEQ command:
SELECT ColumnName, ColumnTitle FROM dbc.ColumnsV
WHERE TABLENAME = 'testview' AND DatabaseName = USER;

ColumnName ColumnTitle
----------------- -----------
InfoKey ?

BTEQ -- Enter your SQL request or BTEQ command:
SELECT * FROM testview;

*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.

bla
------------------------------
VERSION