Search code examples
databasesybase

Show table of database in sybase language


sybase language Hello eveyone, I have a problem i don't understand how to make a basic thing in sybase because i'm a beginner in this language.

I would like show table of a database in sybase but how can i do. I didn't understand the exemple in the official website. what's that "sp_help [ [ @objname = ] 'name' ] " ?! Help me please!


Solution

  • The @objname= is a parameter being passed into the stored procedure. Where it has 'name' you should replace that with your own table name.

    But you don't actually need to do that you can just run the following (obviously replacing tablename with the name of your own table or object):

       sp_help <tablename>