Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

WwWXxX, udp high ports, d-link extract firmware dsl-2750u, wwwwxxxxx.2G, yxxxcom, WWWXXX, ftp://192.168.100.100, wwwxxx 100, www.xxxcon, wwwxxx

Links

XODOX
Impressum

#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

#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