Re: Table Comment

Tim,

Try this

COMMENT ON COLUMN <schema>.<table>.<column> IS '<your_text_here>';

eg

 COMMENT ON COLUMN SCOTT.BONUS.ENAME IS 'Employee Name'

Chris

tim.mcconechy_at_runtime.dk wrote:
>
> Will someone please tell me how I can use, create a Comment on
> an individual column.
>
> I just want some sort of a comment on a specific column.
> I thought it was possible but can't find it in the CRAETE TABLE COMMAND.
>
> If you wanna know why it's because
> I use number(1) as my apps logical field and I want to destinquish
> between number(1) the logical type and number(1) the number type.
>
> It's not obvious by the name ... but with more work it could be.
>
> Otherwise....Any other ideas??
>
> Please CC: My email!
>
> thanks!
> Tusind Tak!
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Jan 29 1999 - 16:48:15 CST