Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

wwwxxx.sunase.sehn..in , w.w.w.x.x.x.con, failed to acquire cryptographic context, high port upd traffic, wwwxxx.con, 0652-010 in backup, Current.ksh, javascript activexobject dll, thomson_de arp requests 0.0.0.0, chasecreditcard.com

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