# Regarding the create table query

**URL:** https://forum.scylladb.com/t/regarding-the-create-table-query/3025
**Category:** ScyllaDB
**Tags:** data-model, troubleshooting, cql
**Created:** [October 9, 2024, 4:38pm UTC](https://forum.scylladb.com/t/regarding-the-create-table-query/3025 "2024-10-09T16:38:55Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Neeraj\_Chatterjee](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.scylladb.com/neeraj_chatterjee/32/1232_2.png) [@Neeraj\_Chatterjee](https://forum.scylladb.com/u/Neeraj_Chatterjee)
#### Post date: [October 9, 2024, 4:38pm UTC](https://forum.scylladb.com/t/regarding-the-create-table-query/3025/1 "2024-10-09T16:38:55Z")

</div>

When I tried creating a table, I wasn’t able to keep certain variable names like token, from etc… I am adding the CQL for create table. Could you please look into it and suggest some alternatives that we can use if we want to keep the field name as token, from and similar to these?

CREATE TABLE email\_template (  
name text PRIMARY KEY,  
service text,  
text\_body text,  
html\_body text,  
subject text,  
priority text,  
from text,  
country text,  
sender\_name text,  
email\_type text,  
created\_by text,  
created\_at bigint,  
updated\_at bigint  
) WITH compaction = {  
‘class’: ‘SizeTieredCompactionStrategy’  
};

On executing the query getting an error: SyntaxException: line 8:4 : Missing ‘)’  
I found some alternative of keeping the variable name as ‘\_from’ but this also fails and gives SyntaxException as mentioned above.

---

<div class="post-metadata">

### Author: ![felipemendes](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.scylladb.com/felipemendes/32/11_2.png) [@felipemendes](https://forum.scylladb.com/u/felipemendes)
#### Post date: [October 9, 2024, 8:43pm UTC](https://forum.scylladb.com/t/regarding-the-create-table-query/3025/2 "2024-10-09T20:43:07Z")

</div>

> from text,

From is a reserved keyword

---

<div class="post-metadata">

### Author: ![Neeraj\_Chatterjee](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.scylladb.com/neeraj_chatterjee/32/1232_2.png) [@Neeraj\_Chatterjee](https://forum.scylladb.com/u/Neeraj_Chatterjee)
#### Post date: [October 23, 2024, 7:02pm UTC](https://forum.scylladb.com/t/regarding-the-create-table-query/3025/3 "2024-10-23T19:02:21Z")

</div>

Thanks Felipe for helping out here.
