Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

kenapa encryption not supported on sql server, wamp configure cluster, csh associative array, 12345678900 क्ष्क्ष्क्स com, mysql database storage capacity, xxxBEF.COmP.4, xxx80www, xxx80www, ksqo, como se resuelve un fatal error: function name must be a string in

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