All:

It is a rare R:BASE session where I do not have this ESSENTIAL R:BASE resource open in a web browser on a second display:

https://www.rbase.com/support/rsyntax/rbgx5/readingcommandsyntax.html

I'm showing the COMMAND syntax URL, but all R:BASE FUNCTIONS are explained there as well; and a ton of other stuff you WILL use.

The R:SYNTAX resource is available from the R:BASE website:

rbase.com | support | Online HTML Documentation | R:Syntax

Choose your flavor: Version 10.0 or 10.5.

Bruce A. Chitiea | SafeSectors, Inc.
112 Harvard Ave #272 | Claremont CA 91711-4716 | USA
[email protected] | +011 (909) 238-9012 c | +011 (909) 912-8678 f

------ Original Message ------
From: [email protected]
To: [email protected]
Sent: 9/4/2021 2:42:25 PM
Subject: RE: [RBASE-L] - Database Columns Report

From the R> prompt type:

LIST YourTableName

And it will display the columns in the selected table and will stop and prompt based on your LINES setting and will place a header accordingly. You can adjust the lines setting using:

SET LINES 50

Or whatever value you want; I believe 20 is the default.

You can select the information and copy it using CTRL-C and paste it into your favorite editor for further formatting using CTRL-V. You can also send it directly to the printer using:

OUTPUT PRINTER

LIST YourTableName

OUTPUT SCREEN

Or using just one command:

OUTPUT PRINTER; LIST YourTableName; OUTPUT SCREEN

Hopefully this will get you started.



Javier,



Javier Valencia, PE

913-915-3137



From:[email protected] <[email protected]> On Behalf Of Gary Randall
Sent: Saturday, September 4, 2021 4:24 PM
To:[email protected]
Subject: [RBASE-L] - Database Columns Report



Hello All,



Is there a way to print out all the columns in a table? I am looking for a way to print out the database tables and columns names.



Thank you

Gary Randall



--
For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/MW3PR16MB38524245E5AA3BF31B47070CF6D09%40MW3PR16MB3852.namprd16.prod.outlook.com <https://groups.google.com/d/msgid/rbase-l/MW3PR16MB38524245E5AA3BF31B47070CF6D09%40MW3PR16MB3852.namprd16.prod.outlook.com?utm_medium=email&utm_source=footer>.


--
For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAG1gU%2BA71stIig71BAFnx9iihQAAEAAAAGp8YZq4RERMtcB9dIdwK8wBAAAAAA%3D%3D%40vtgonline.com <https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAG1gU%2BA71stIig71BAFnx9iihQAAEAAAAGp8YZq4RERMtcB9dIdwK8wBAAAAAA%3D%3D%40vtgonline.com?utm_medium=email&utm_source=footer>.

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/em7f5cb2d6-658a-4d6e-983e-38fdd80de712%40pathfinder.

Reply via email to