Add metadata tag to teradata objects

Question

I have several stored procedures in Teradata that I wish to label. Therefore, I'm looking for a way to add metadata to an object in Teradata. I've been looking into Teradata's Data Dictionary, but it seems the only way is to add labels as comments.

Is there a better way to tag, label and/or identify stored procedures in Teradata?

What exactly do you mean by *add metadata*, can you show an example? — dnoeth, Nov 15 '22 at 14:10
Do you perhaps mean [query bands](https://docs.teradata.com/r/rgAb27O_xRmMVc_aQq2VGw/sME3hVgEFSOZHQh_qyV8_Q)? — Andrew, Nov 15 '22 at 15:50

score 1 · Answer 1 · answered Nov 16 '22 at 00:43

1

Comment placement

comment on procedure <database_name>.<procedure_name> 'test procedure';

Comment retrieval

comment on procedure <database_name>.<procedure_name>;

answered Nov 16 '22 at 00:43

access_granted

1,807
20
25

Add metadata tag to teradata objects

1 Answers1