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
N/A

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

N/A

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