Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

error 800c5000, Wwwxxxc,memo, inserting images in postgresql, sending diag reset !!, bhavin retain ni style words, Www.ottest3, Php-cgi.exe not found , unable to change directory to null, www.xxx.con, kerio and iis post same error

Links

Issociate
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