# Create a View over a Table using DreamFactory panel

**URL:** <https://community.dreamfactory.com/t/create-a-view-over-a-table-using-dreamfactory-panel/2075>\
**Category:** Connecting to SQL\
**Created:** [January 22, 2016, 10:09am UTC](https://community.dreamfactory.com/t/create-a-view-over-a-table-using-dreamfactory-panel/2075 "2016-01-22T10:09:14Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![bugdroid](https://avatars.discourse-cdn.com/v4/letter/b/8dc957/32.png) [@bugdroid](https://community.dreamfactory.com/u/bugdroid)\
**Post date:** [January 22, 2016, 10:09am UTC](https://community.dreamfactory.com/t/create-a-view-over-a-table-using-dreamfactory-panel/2075/1 "2016-01-22T10:09:14Z")

</div>

I have created a Database Service, them created a Table and populated the Table with some data.

Where can I create my own views using DreamFactory panel? I have the SQL code for the view but don’t know where to create it.

Later on i want to do a REST GET request on this View.

---

<div class="post-metadata">

**Author:** ![formerstaff](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/formerstaff/32/1133_2.png) [@formerstaff](https://community.dreamfactory.com/u/formerstaff)\
**Post date:** [January 22, 2016, 2:40pm UTC](https://community.dreamfactory.com/t/create-a-view-over-a-table-using-dreamfactory-panel/2075/2 "2016-01-22T14:40:55Z")

</div>

@bugdroid DreamFactory does not have the functionality for creating and editing views, functions, and procedures. To do that you’ll need to use a dedicated SQL tool.