Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2011
    Posts
    3

    Unanswered: Sybase Table name case sensitiveness

    Hi,

    I have created 2 tables "stud_details" and "Stud_Details"

    In the stored procedure, i have used as "Stud_details"

    Now which table willl be loaded once the procedure is run.

    Can someone tell me about the case sensitiveness(of tables names, columns etc..) in sybase


    Thanks in advance

  2. #2
    Join Date
    May 2011
    Posts
    28

    Sybase Table name case sensitiveness

    Hi,
    Object names are case sensitive. Object id will be different for difefrent name.
    You can query into sysobjects table for the object id.
    use sp_depends <object name> to check the dependent object.
    Here stored procedure will not be installed as table Stud_details does not exist in the database.

Posting Permissions

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