UniVerse SQL View All Tablenames

Question

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?

Answer 1

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]"

Answer 2

USE THIS SINTAXIS

a)... THIS IS FOR CONTENTS

LIST (NAME OF DATABASE)

b) ... THIS IS FOR DICTIONARY

LIST DICT (NAME OF DATABASE)

Answer 3

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.