# set default Schema for SQL Server **URL:** \ **Category:** CData Sync\ **Tags:** question\ **Created:** [October 1, 2024, 5:09pm UTC](https://community.cdata.com/t/set-default-schema-for-sql-server/908 "2024-10-01T17:09:21Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Slacker](https://avatars.discourse-cdn.com/v4/letter/s/6bbea6/32.png) [@Slacker](https://community.cdata.com/u/Slacker)\ **Post date:** [October 1, 2024, 5:09pm UTC](https://community.cdata.com/t/set-default-schema-for-sql-server/908/1 "2024-10-01T17:09:21Z")
Is there a way to set a default Schema to default to when saving information into SQL server?  I know how to do it by each table but find my self forgetting from time to time. ---
**Author:** ![DougN\_Nouria](https://avatars.discourse-cdn.com/v4/letter/d/e0b2c6/32.png) [@DougN\_Nouria](https://community.cdata.com/u/DougN_Nouria)\ **Post date:** [October 1, 2024, 5:16pm UTC](https://community.cdata.com/t/set-default-schema-for-sql-server/908/2 "2024-10-01T17:16:24Z")
If you go into the Connection for the SQL Server, Advanced tab, scroll down to the Schema section… if you set a single Browsable Schema, does it default that one in for you automatically going forward? ---
**Author:** ![Ethem\_Q](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/ethem_q/32/1997_2.png) [@Ethem\_Q](https://community.cdata.com/u/Ethem_Q)\ **Post date:** [October 8, 2024, 4:29pm UTC](https://community.cdata.com/t/set-default-schema-for-sql-server/908/3 "2024-10-08T16:29:08Z")
Hi @Slacker The easiest way to set the schema in the destination to default to an SQL Server schema of your choice would be to simply set the ‘Destination Schema’ property in the Overview tab when opening the job. See screenshot for reference: ![365a659d-ee51-4756-b13c-eee0038aa2f4.png](https://us1.discourse-cdn.com/cdata/original/2X/2/2c6e1da1fc60c9adfe4af4a425e08361e3dbea51.png) If you have any other questions don’t hesitate to reach out to the support team at [support@cdata.com](mailto:support@cdata.com).