# Get all tables in sql in air application

**URL:** <https://forum.kirupa.com/t/get-all-tables-in-sql-in-air-application/312379>\
**Category:** Uncategorized\
**Created:** [August 1, 2010, 7:43pm UTC](https://forum.kirupa.com/t/get-all-tables-in-sql-in-air-application/312379 "2010-08-01T19:43:56Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![cakepizza](https://avatars.discourse-cdn.com/v4/letter/c/45deac/32.png) [@cakepizza](https://forum.kirupa.com/u/cakepizza)\
**Post date:** [August 1, 2010, 7:43pm UTC](https://forum.kirupa.com/t/get-all-tables-in-sql-in-air-application/312379/1 "2010-08-01T19:43:56Z")

</div>

I can’t figure out for the life of me why I can’t get this to select all tables.

If I select a specific table it works…

```auto
var Table="Table1";
var Columns="*";
myStatement.text = "SELECT "+Columns+" FROM "+Table;

```

but when I try to select all tables like this…

```auto
var Table="*";
var Columns="*";
myStatement.text = "SELECT "+Columns+" FROM "+Table;

```

I get this error message…  
SQLError: ‘Error #3115: SQL Error.’, details:‘near ‘\*’: syntax error’, operation:‘execute’, detailID:‘2003’

It seems like this should be working because in the documentation it says,  
"If a result expression is \* then all columns of all tables are substituted for that one expression. "

here is the docs.  
[http://livedocs.adobe.com/flex/3/langref/localDatabaseSQLSupport.html#dataManipulation](http://livedocs.adobe.com/flex/3/langref/localDatabaseSQLSupport.html#dataManipulation)

Anyone have an idea what I am doing wrong?  
Thanks!