Results 1 to 2 of 2

Thread: Viewing Tables

  1. #1
    Join Date
    Jan 2012
    Posts
    1

    Unanswered: Viewing Tables

    Hello,
    I'm new to sybase and have been given the task of trying to fix up an old database that was written several years ago. It runs under PowerBuilder 7.0

    So far I have been able to get a list of the tables using interactive SQL

    select id, name, type from sysobjects;

    Give a long table that looks like

    100199,'TRANS_TYP','U'
    100200,'STF_NME','U'
    100201,'STF','U'
    100202,'PRNT_PHN','U'
    100203,'PRNT_NME','U'
    100204,'AGE_CAT','U'
    100205,'FEES','U'
    100206,'rev_temp','U'
    100207,'AR_PROCESSED','U'

    I understand that U stands for User Tables and should be the ones I am interested in.

    For instance
    select * from FEES;

    Gives me an error "Error at line 1 Table 'FEES' not found"

    I have tried a few variations and haven't had much luck. Was I incorrect on the table name? Any help would be appreciated.

    -----------------------------------------------------------------------------------------------------
    Found the fault! It seems the dba account I was given didn't have the correct permissions. I found the correct one and now it works.
    Thanks!
    Last edited by felware; 01-23-12 at 15:09. Reason: Found the fault

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    You also need to consider the uid
    user_name(uid)
    assuming the database uid belongs to mark then
    then select * from mark.FEES

Posting Permissions

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