Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2005
    Posts
    2

    Unanswered: Type field in sysobjects

    Hi All
    I am new to sybase and also to this group. i am actually stuck up at a requirement where I have to take out all the database objects which are not of system. when I executed the query ("select name,type from sysobjects") it gave me a huge list with types (P,R,RI,U,V) can anybody please help me in decoding these types. What these types means???

    HELP HELP HELP

    Thanks
    Vikky

  2. #2
    Join Date
    Sep 2005
    Location
    France, Paris
    Posts
    34

    Hello !

    Hi,

    Well, here is all the type definitions you find in sysobjects table :

    D - default
    F - SQLJ function
    L - log
    P - Transact-SQL or SQLJ procedure
    PR - prepare objects (created by Dynamic SQL)
    R - rule
    RI - referential constraint
    S - system table
    TR - trigger
    U - user table
    V - view
    XP - extended stored procedure

    So, if you need the name of all stored procedures in a database for instance you can do :

    select name from sysobjects where type = 'P'


    Here you can find the online sybase documentation refering to the sysobjects table (ASE v12.5.1): HERE
    Regards.

  3. #3
    Join Date
    Sep 2005
    Posts
    2
    Thanks a million jflebon.
    It was a great help...

    cheers,
    Vikky

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •