September 9, 2013 at 4:21 pm
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..
September 10, 2013 at 3:43 am
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply