Post reply

xtype 99

  • June 18, 2008 at 9:13 am

    #129537

    Hi everyone

    in SYSCOLUMNS System table what does XTYPE = 99 or xtype = 35 ,

    from books online it is reffering physical storage but i did not really understand.

    please provide light on.

    thanks in advance.

  • June 18, 2008 at 9:24 am

    #830563

    I beleive but may be wrong that it represnts the datatype of the column in question.

    35 = Text

    99 = NText

    Gethyn Elliswww.gethynellis.com

  • June 18, 2008 at 11:37 am

    #830659

    Seems to be not appropriate.may be i must be wrong.

    do any one give some insight on this .

  • June 18, 2008 at 12:14 pm

    #830682

    I think Ellis is right:

    select name, system_type_id

    from sys.types

    where system_type_id in (35,99)

    name system_type_id

    -----------------------

    text 35

    ntext 99


    * Noel

  • June 18, 2008 at 12:24 pm

    #830687

    xtype column in syscolumns refer to the type id of each datatype or user defined datatype. xtype maps to system_type_id column in sys.types table.

    sys.types view contains all information abount datatypes (including user defined data types).

    for example lets create a table

    create table abc(a varchar(100))

    if you query the syscolumns table to get the xtype of the column a,

    select xtype from syscolumns where id=object_id('abc'), you will get 167.

    then query the sys.types table

    select * from sys.types where system_type_id=167, you will see the row corresponds to varchar.


    subban

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply