How to list all tables that exist on kdb server?

[Simon]

Hi,

How do I list all tables that exist on the kdb server?
The standard SQL commands show tables; does not work.
In qStudio it lists all tables / views / variables.

-Simon

[John Dempster]

To show variables that exist on the server there are a number of system or slash commands:

q)t:([] a:1 2)
q)s:([] b:3 4)
q)v:1
q)f:{x}
q)vieww::select from t where i<1

System or slash a to show tables.
q)system “a”
`s`t
q)\a
`s`t
q)tables[]
`s`t

b is views, v is variables, f is functions
q)\b
,`vieww
q)\v
`b`s`t`v
q)\f
`cls`f`regr

Or key shows all objects that exist in a namespace:

q)key `.
`cls`regr`b`t`s`v`f`vieww

• This reply was modified 11 years, 7 months ago by John Dempster.

[Author]

Posts