Where to find field properties in SQL Server

JanM

Hi
We are extracting warehouse data from the navision tables in sql server 2005. We can't find the table which holds the field properties, especialy from type option where you can find the option string.
Also wondering about where the code is stored, just for to know.

Thanks for a tip.
Jan

ara3n

Hello JanM
They are not stored anywhere. You would need to create a table for all the option fields and include the options.