List tables

Results 1 to 2 of 2

Thread: List tables

  1. #1
    Join Date
    Dec 1969

    Default List tables

    Does anyone know the SQL syntax for SQL server(7) of the DB2 statement LIST TABLES?<BR><BR>Basically i want to see all the table names in a database using query analyser rather than enterprise manager.

  2. #2
    Join Date
    Dec 1969

    Default sp_help

    "exec sp_help" gives you a list of all database objects. Have a look in Books Online for more info on how to use this procedure.

Posting Permissions

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