What's the equivalent of "Show Tables" in SQSH

Question

How can I get sqsh to tell me which tables are available?

possible duplicate of [From a Sybase Database, how I can get table description ( field names and types)?](http://stackoverflow.com/questions/1429898/from-a-sybase-database-how-i-can-get-table-description-field-names-and-types) — null, Dec 12 '13 at 03:41

score 9 · Answer 1 · answered Jun 04 '09 at 01:35

9

Does sp_tables work for you? Are you trying to get tab completion when creating a query?

answered Jun 04 '09 at 01:35

brianegge

26,898
12
70
97

**sp_help [ – gavenkoa Apr 25 '14 at 05:29

score 6 · Accepted Answer · answered May 01 '09 at 14:56

6

After some help from this site and some trial and error:

 select table_name from systable
 go

Painfully enough, sp_help doesn't exist in my version.

answered May 01 '09 at 14:56

rampion

82,104
41
185
301

1

This seems to be specific for a certain Sybase version as it doesn't work on ASE. Are you using IQ? – VolkA Apr 22 '13 at 09:10

score 5 · Answer 3 · answered May 23 '13 at 08:00

5

Newer version use sysobjects:

SELECT name FROM sysobjects WHERE type = 'U';

Regards,

answered May 23 '13 at 08:00

user1126070

4,999
1
14
14

score 2 · Answer 4 · answered May 29 '09 at 02:45

I am not familiar with systables. What flavor of Sybase are you running? ASA perhaps?

Please find appended a sqsh function (which you can put in your .sqshrc) which demonstrates some querying of the ASE (Adaptive Server Enterprise) catalog tables and the use of the Ed Barlow system stored procedure library http://www.edbarlow.com/gem/procs_only/index.htm to figure out what objects are in a database.

# Shorthand for sp__helptext or sp__revtable
\func -x ?
  IF EXISTS (SELECT * FROM sysobjects WHERE name = \\'${1}\\')
       BEGIN
       DECLARE @type VARCHAR(3)
       SELECT @type = type FROM sysobjects WHERE name = \\'${1}\\'
       IF @type IN (\\'U\\')
          exec sp__revtable ${1}
       ELSE
          exec sp__helptext ${1}
        END
   ELSE
       -- default to sp__ls (which can list partial matches) if an exact match wasn't found in sysobjects
       exec sp__ls ${1}
   go
\done

select name from sysobjects where xtype='U' – denis.peplin Sep 17 '12 at 05:52 — denis.peplin, Sep 17 '12 at 05:52

What's the equivalent of "Show Tables" in SQSH

4 Answers4