# listStreamingSQLTables {#listStreamingSQLTables}

**Parent topic:**[Functions](../../Functions/category.md)

## Syntax {#syntax}

`listStreamingSQLTables()`

## Arguments {#arguments}

None.

## Details {#details}

List all streaming SQL tables declared via `declareStreamingSQLTable`. Return streaming SQL tables of all users in the system if called by the admin.

**Return value**: A table containing the following columns: tableName, shared, users.

## Examples {#examples}

``` {#codeblock_y55_32x_mgc}
t=table(1..10 as id,rand(100,10) as val)
share t as st
declareStreamingSQLTable(st)

listStreamingSQLTables()
```

|tableName|shared|users|
|---------|------|-----|
|st|true|admin|

**Related functions:** [declareStreamingSQLTable](../d/declareStreamingSQLTable.md)

