column data types?

28 Dec 2005 9:56 PM

Les Stockton

I know there's a way to query the schema, but don't recall exactly. Does
anyone know how to query the database to determine the field type, length,
precision, scale, etc?

28 Dec 2005 10:04 PM

Les Stockton

By the way, I know there was an undocumented stored procedure to do this too,
but it returned the datatype string as the 3rd argument, and since I'm hoping
to receive this in a recordset (although one row) from an ADODB.Connection in
VB, I'm not sure how to take that 3rd argument and get it to the recordset.

Show quote

"Les Stockton" wrote:

> I know there's a way to query the schema, but don't recall exactly. Does
> anyone know how to query the database to determine the field type, length,
> precision, scale, etc?
>

28 Dec 2005 10:15 PM

Aaron Bertrand [SQL Server MVP]

www.aspfaq.com/2177

Show quote

"Les Stockton" <LesStock***@discussions.microsoft.com> wrote in message
news:7CFEB2D5-4C65-4353-A350-4FF755F0C478@microsoft.com...
>I know there's a way to query the schema, but don't recall exactly. Does
> anyone know how to query the database to determine the field type, length,
> precision, scale, etc?
>