#1: Get data type of column

Posted on 2005-08-17 15:53:24 by Mike

How do I get a textual description of the data type of a SQL Server table
column?

(Returned to ASP preferably)

Report this message

Mr Ad

Google

#2: Re: Get data type of column

Posted on 2005-08-17 15:55:59 by David Portas

SELECT data_type
FROM information_schema.columns
WHERE table_schema = 'dbo'
AND table_name = 'table_name'
AND column_name = 'col' ;

--
David Portas
SQL Server MVP
--

Report this message

#3: Re: Get data type of column

Posted on 2005-08-17 16:28:53 by reb01501

Mike wrote:
> How do I get a textual description of the data type of a SQL Server
> table column?
>
> (Returned to ASP preferably)
It depends on if you want the T-SQL datatype, or the vbscript datatype, or
the jscript datatype if you are using jscript.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Report this message

#4: Re: Get data type of column

Posted on 2005-08-17 21:37:19 by Hari Prasad

Hi,

Execute the system procedure

sp_columns <Table_name>

Thanks
Hari
SQL Server MVP



"Mike" <mike@hello.com> wrote in message
news:OaxhvLzoFHA.3828@TK2MSFTNGP12.phx.gbl...
> How do I get a textual description of the data type of a SQL Server table
> column?
>
> (Returned to ASP preferably)
>

Report this message