November 15, 2003 at 3:06 pm
I wish to know from where I can extract the following information from the system tables/procedures/views :
Description,Default Value,Precision,Scale,Identity,Identity Seed,Identity Increment,Is RowGuid,Formula
I have tried looking everywhere for this metadata but am not able to find this information.
TIA
Ratan
November 17, 2003 at 4:05 am
A start might be to look at
COLUMNPROPERTY
TYPEPROPERTY
and Meta Data -> functions in BOL
An alternative might be to search for Meta Data on this site. Should return some interesting hits.
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 17, 2003 at 6:31 am
It might be easiest to just get this information using SQL-DMO, where they are all properties of the column object, except for "Description"; is that an extended property?
--Jonathan
--Jonathan
November 17, 2003 at 6:38 am
I think this 'Description' is more for Analysis Services. Access uses a description 'field' which is user-defined.
You could use fn_listextendedproperty to list these extended properties, but I think it will return nothing unless you haven't added some extended properties first.
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply