# Create new schema

**URL:** <https://community.cratedb.com/t/create-new-schema/828>\
**Category:** SQL\
**Created:** [September 27, 2021, 4:23pm UTC](https://community.cratedb.com/t/create-new-schema/828 "2021-09-27T16:23:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Raghavendra\_Hegde](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/raghavendra_hegde/32/400_2.png) [@Raghavendra\_Hegde](https://community.cratedb.com/u/Raghavendra_Hegde)\
**Post date:** [September 27, 2021, 4:23pm UTC](https://community.cratedb.com/t/create-new-schema/828/1 "2021-09-27T16:23:02Z")

</div>

how to create new schema on CrateDB?

I tried with below command and got error.

CREATE SCHEMA test2 AUTHORIZATION testuser;

Error!

SQLParseException[line 1:8: no viable alternative at input ‘CREATE SCHEMA’]

---

<div class="post-metadata">

**Author:** ![proddata](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/proddata/32/1379_2.png) [@proddata](https://community.cratedb.com/u/proddata)\
**Post date:** [September 27, 2021, 8:28pm UTC](https://community.cratedb.com/t/create-new-schema/828/2 "2021-09-27T20:28:34Z")

</div>

In CrateDB you can just create a table within a schema like

```sql
CREATE TABLE schema_name.table_name

```

Also, you can grant rights like so on a schema (even if it doesn’t explicitly exists yet):

```sql
GRANT DQL ON SCHEMA schema_name TO user_name;

```

> In CrateDB, schemas are just namespaces that are created and dropped implicitly. Therefore, when `GRANT` , `DENY` or `REVOKE` are invoked on a schema level, CrateDB takes the schema name provided without further validation.