How to list all tables that exist on kdb server? - Kdb+ / qStudio

Home Forums Kdb+ / qStudio How to list all tables that exist on kdb server?

Tagged: 

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #250

    Simon
    Guest

    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

    #256

    John Dempster
    Keymaster

    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, 6 months ago by John Dempster.
Viewing 2 posts - 1 through 2 (of 2 total)

The topic ‘How to list all tables that exist on kdb server?’ is closed to new replies.