Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2010
    Posts
    4

    Unanswered: dbo.systable not found error

    Hi,
    I am getting the following error when i try to select on systable table

    208: dbo.systables not found. Specify owner objectname or use sp_help...

    I am unable to exec sp_help so if anyone can tell me some other workaround for that.

  2. #2
    Join Date
    Aug 2010
    Posts
    4
    Ok after GOOGLing i found that we can use sysobjects as well.
    Now the issue is that systypes.name shows some datatypes (like tCallTime, tDNIS_PREFIX). These datatypes are new for me. Can someone give the details of these datatypes.
    Actually I have to create the DDL from sybase and run them on other DBs. I am using the following query.

    select syscolumns.name as columnname,
    systypes.name as typename,
    syscolumns.length,
    syscolumns.prec as "significant digits",
    syscolumns.scale as "fraction",
    syscolumns.type,
    syscolumns.usertype
    from sysobjects, syscolumns, systypes
    where sysobjects.id=syscolumns.id
    and systypes.usertype=syscolumns.usertype
    and sysobjects.name = 'my_tb_name'

  3. #3
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    tCallTime and tDNIS_PREFIX probably are user defined datatypes. All other information about UDDT is in systypes too (length, allow null, precision, scale)
    I'm not crazy, I'm an aeroplane!

  4. #4
    Join Date
    Aug 2010
    Posts
    4
    Is there any way to check a user defined data type. I mean is there any flag in the table or something like this that tells that it is a user defined data type or not?
    And also can we see the defination of these user defined data types?

  5. #5
    Join Date
    Nov 2002
    Posts
    21
    systable alway exists in asa.

  6. #6
    Join Date
    Aug 2010
    Posts
    4
    okay thanks all, till now.

Posting Permissions

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