UniVerse SQL View All Tablenames

604 Views Asked by At

I am new to UniVerse. I am working with an existing Database. I would like to know how to View a List of all available TABLES in the database. Is there a simply syntax command to view all TABLES?

3

There are 3 best solutions below

2
On

At TCL:

LIST VOC WITH F1 = "F]"

This will list all file/table entries registered in a specific account (database) on the database server.

If you're looking for all accessible files, including files that may be in other accounts (databases) on the server, use the following query:

LIST VOC WITH F1 = "F]" OR F1 = "Q]"
0
On

USE THIS SINTAXIS

a)... THIS IS FOR CONTENTS

LIST (NAME OF DATABASE)

b) ... THIS IS FOR DICTIONARY

LIST DICT (NAME OF DATABASE)

0
On

Type "F" would only return results of physical files in that account. Type "Q" are Q-Pointers that point to physical files in other accounts. This is a way to have one file, but several accounts point to that file.