Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

LABEL ON COLUMN Expand / Collapse
Author
Message
Posted Monday, September 9, 2013 4:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 14, 2014 6:39 AM
Points: 1, Visits: 3
I use SQL to create tables. In DB2 on IBM iSeries I use:

LABEL ON COLUMN IS and TEXT IS ?

example:

LABEL ON COLUMN JMALIBX.FDKEYS
( APRCEN IS 'Retrieval Century' ,


APRCEN TEXT IS 'Retrieval century: 0=19xx, 1=20xx' ,

what is the difference between these for other databases like MySQL etc..
Post #1492949
Posted Tuesday, September 10, 2013 3:43 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 8:22 AM
Points: 14,205, Visits: 28,534
I don't know MySQL at all, but on a SQL Server instance it sounds like you're talking about extended properties. The ability to add additional, meta-data, about the columns or tables within the database. You can read about them in the books online.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server Query Performance Tuning
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1493068
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse