> ## Documentation Index
> Fetch the complete documentation index at: https://docs.maia.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Alter Table



\<table><tbody><tr><td>Project Availability</td>
            \<td /></tr>
          \<tr><td>Component Type</td>
            \<td>Orchestration</td></tr>
          \<tr><td>Connection Inputs</td>
            \<td>One</td></tr>
          \<tr><td>Connection Outputs</td>
            \<td>Unlimited</td></tr></tbody></table>

The Alter Table component lets users enable or disable the Snowflake Search Optimization Service on any table, provided the table uses the supported data types of Integer, Numeric, Date, Time, Timestamp, Varchar, or Binary.> [!NOTE]
>
> This component is specifically for managing the Search Optimization Service and doesn't support general schema changes, such as adding or removing columns. To change a table's schema, use the [SQL Script](https://docs.maia.ai/docs/components/sql-script.md) component to run an `ALTER TABLE` statement.For more information, read [Using the Search Optimization Service](https://docs.snowflake.com/en/user-guide/search-optimization-service#using-the-search-optimization-service) in Snowflake's documentation.***## Properties**Name** `string` *required*A human-readable name for the component.**Target Table** `drop-down` *required*Select the table to alter. The tables available to select are determined by the selected Snowflake database and schema.**Schema** `drop-down` *required*The Snowflake schema. The special value `[Environment Default]` uses the schema defined in the environment. Read [Database, Schema, and Share DDL](https://docs.snowflake.com/en/sql-reference/ddl-database.html) to learn more.**Database** `drop-down` *required*The Snowflake database. The special value `[Environment Default]` uses the database defined in the environment. Read [Databases, Tables and Views - Overview](https://docs.snowflake.com/en/guides-overview-db) to learn more.**Search Optimization Service** `drop-down` *required*Turn on or off the search optimization service. For more information, read [Using the Search Optimization Service](https://docs.snowflake.com/en/user-guide/search-optimization-service#using-the-search-optimization-service) in Snowflake's documentation.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.