Dictionary table

I heard that the term "dictionary table" but I can't find it on MSDN.
Any idea?
zhshqzycAsked:
Who is Participating?
 
Scott PletcherConnect With a Mentor Senior DBACommented:
I agree.  I think they mean the system views (technically they are views not tables) in SQL Server.

Btw, you should use the MS views:

sys.object
sys.columns
etc.

and NOT the information_schema views, since, ironically, the schema name in those views may be incorrect in SQL 2005 and later.
0
 
tigin44Commented:
I assume you have heard about the dictionary data type.. in this link a brief explanion is given with examples.

http://www.dotnetperls.com/dictionary-vbnet
0
 
zhshqzycAuthor Commented:
No. I know direction data. I heard that there is a kind of table called "Dictionary Table".
0
 
Chris LuttrellConnect With a Mentor Senior Database ArchitectCommented:
There is nothing in MS SQL Server that is directly called a Dictionary Table.  Other flavors of SQL often refer to SYSTEM tables as Dictionary Tables, is that what you are looking for.  If so look for sys or system tables in MS SQL.
0
 
agusacilConnect With a Mentor Commented:
Perhaps what you mean is metadata, that is information about database's table structure.
You can retrieve that from information_schema.
Further information can be read here
http://msdn.microsoft.com/en-us/library/ms186778.aspx

Or here
http://www.databasejournal.com/features/mssql/article.php/1460131/SQL-Servers-Metadata-Views.htm
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.