# Api for ATTACH DATABASE

**URL:** <https://discuss.zetetic.net/t/api-for-attach-database/3427>\
**Category:** Issues\
**Created:** [February 13, 2019, 1:16pm UTC](https://discuss.zetetic.net/t/api-for-attach-database/3427 "2019-02-13T13:16:42Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![pdp](https://avatars.discourse-cdn.com/v4/letter/p/cab0a1/32.png) [@pdp](https://discuss.zetetic.net/u/pdp)\
**Post date:** [February 13, 2019, 1:16pm UTC](https://discuss.zetetic.net/t/api-for-attach-database/3427/1 "2019-02-13T13:16:42Z")

</div>

Hi,  
Is there any API available to ATTACH DATABASE, instead of passing it as an sql query to sqlite3\_exec? I am using sqlcipher version:  
3.7.17 2013-05-20 00:56:22 118a3b35693b134d56ebd780123b7fd6f1497668

char \*db\_ssl\_key=“abcd”;  
sprintf(sqlQuery,“ATTACH DATABASE ‘/tmp/encrypted.db’ AS encrypted KEY ‘%s’”,db\_ssl\_key);  
if(sqlite3\_exec(persistence\_db, sqlQuery, NULL, NULL, &zErrMsg) != SQLITE\_OK)  
printf(“Error while attaching”);

---

<div class="post-metadata">

**Author:** ![developernotes](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.zetetic.net/developernotes/32/1309_2.png) [@developernotes](https://discuss.zetetic.net/u/developernotes)\
**Post date:** [February 13, 2019, 2:07pm UTC](https://discuss.zetetic.net/t/api-for-attach-database/3427/2 "2019-02-13T14:07:00Z")

</div>

Hello @pdp,

You could also use a compiled statement through the [`sqlite3_prepare`](https://www.sqlite.org/c3ref/prepare.html) API.