|
Home > Archive > ASE Database forum > March 2006 > How can I know the type(name) of a column?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How can I know the type(name) of a column?
|
|
| Manuel Espinoza 2006-03-05, 8:42 pm |
| Hi!
ASE 11.92
I know that is in systypes where I can find this info; however, some
datatypes id are repeated(for example, 39), or at least I don't know ho to
filter them.
Here's the query:
select c.name, t.type, t.name, c.length, c.usertype,
c.prec, c.scale, '', c.type
from dbo.syscolumns c, systypes t
where c.type = t.type
and c.id = object_id('cxcmov')
and c.cdefault = 0
Many thanks in advance.
| |
| Mark A. Parsons 2006-03-05, 8:42 pm |
| Recommend grabbing a copy of the source code for sp_help, ie, see how
sp_help handles the duplicate datatype id's.
Manuel Espinoza wrote:
> Hi!
>
> ASE 11.92
>
> I know that is in systypes where I can find this info; however, some
> datatypes id are repeated(for example, 39), or at least I don't know ho to
> filter them.
>
> Here's the query:
>
> select c.name, t.type, t.name, c.length, c.usertype,
> c.prec, c.scale, '', c.type
> from dbo.syscolumns c, systypes t
> where c.type = t.type
> and c.id = object_id('cxcmov')
> and c.cdefault = 0
>
>
> Many thanks in advance.
>
>
>
|
|
|
|
|