# **CREATE DYNAMIC TABLE**

## **Grammar Description**

`CREATE DYNAMIC TABLE` Adds a new dynamic table to the current database.

## **Grammar Structure**

```sql
CREATE DYNAMIC TABLE [IF NOT EXISTS] table_name
AS SELECT ... from stream_name ;
```

## Syntax Explanation

- table_name: Dynamic table name. The dynamic table name must be different from any existing dynamic table name in the current database.
- stream_name: The name of the SOURCE that has been created.

## **Example**

```sql
create dynamic table dt_test as select * from stream_test;
Query OK, 0 rows affected (0.01 sec)
```

## limit

When creating dynamic tables, the use of aggregate functions, mathematical functions, string functions, date functions, as well as `limit, offset`, `from subquery`, `not in/in subquery`, `group by`, `order by`, and having` statements are not supported.

When creating dynamic tables, joins, SOURCE tables and ordinary data tables are not supported for the two SOURCE tables.