# Lancedb > Add new columns to a table using SQL expressions that can reference existing columns. You can generate computed columns or add null-filled columns with explicit type casting. ## Pages - [Add Columns](add-columns.md): Add new columns to a table using SQL expressions that can reference existing columns. You can generate computed colum... - [Add new columns to table schema](add-new-columns-to-table-schema.md): ## Documentation Index - [Advanced Configuration](advanced-configuration.md): ## Documentation Index - [Alter information of a transaction.](alter-information-of-a-transaction.md): ## Documentation Index - [Analyze query execution plan](analyze-query-execution-plan.md): ## Documentation Index - [Answer.AI Rerankers](answerdotai.md): ## Documentation Index - [Architecture](architecture.md): ## Documentation Index - [AWS Bedrock](aws.md): ## Documentation Index - [Azure deployment guide](azure.md): ## Documentation Index - [Backfilling](backfilling.md): ## Documentation Index - [Benchmarks](benchmarks.md): ## Documentation Index - [Blob Types in Geneva UDFs](blobs.md): ## Documentation Index - [Check if a namespace exists](check-if-a-namespace-exists.md): ## Documentation Index - [Check if a table exists](check-if-a-table-exists.md): ## Documentation Index - [Cohere](cohere.md): ## Documentation Index - [ColBERT Reranker](colbert.md): ## Documentation Index - [ColPali](colpali.md): ## Documentation Index - [Configuring Cloud Storage in LanceDB](configuration.md): ## Documentation Index - [Backfill Conflicts](conflicts.md): ## Documentation Index - [Consistency](consistency.md): ## Documentation Index - [Geneva Console](console.md): ## Documentation Index - [Execution Contexts](contexts.md): ## Documentation Index - [Count rows in a table](count-rows-in-a-table.md): ## Documentation Index - [Count Table Rows](count-table-rows.md): Count the number of rows in a table with optional filtering. You can pass a SQL predicate to count only the rows that... - [Create a new namespace](create-a-new-namespace.md): ## Documentation Index - [Create a new tag](create-a-new-tag.md): ## Documentation Index - [Create a scalar index on a table](create-a-scalar-index-on-a-table.md): ## Documentation Index - [Create a table with the given name](create-a-table-with-the-given-name.md): ## Documentation Index - [Create an empty table](create-an-empty-table.md): ## Documentation Index - [Create an index on a table](create-an-index-on-a-table.md): ## Documentation Index - [Create Index](create-index.md): Create an index on a table column to optimize search performance for vector, scalar, or full-text search operations. ... - [Create Table](create-table.md): Create a new table in the database with schema inferred from the provided Arrow data. The table name must be unique w... - [Ingesting Data](create.md): ## Documentation Index - [Cross Encoder Reranker](cross-encoder.md): ## Documentation Index - [Building Custom Rerankers](custom-reranker.md): ## Documentation Index - [Declare a table](declare-a-table.md): ## Documentation Index - [Delete a tag](delete-a-tag.md): ## Documentation Index - [Delete Data](delete-data.md): Delete rows from a table using a SQL predicate filter. The delete operation permanently removes rows that match the s... - [Delete rows from a table](delete-rows-from-a-table.md): ## Documentation Index - [Dependency Verification](dependency-verification.md): ## Documentation Index - [Deregister a table](deregister-a-table.md): ## Documentation Index - [Describe a namespace](describe-a-namespace.md): ## Documentation Index - [Describe information about a transaction](describe-information-about-a-transaction.md): ## Documentation Index - [Describe information of a table](describe-information-of-a-table.md): ## Documentation Index - [dlt](dlt.md): ## Documentation Index - [Drop a namespace](drop-a-namespace.md): ## Documentation Index - [Drop a specific index](drop-a-specific-index.md): ## Documentation Index - [Drop a table](drop-a-table.md): ## Documentation Index - [Drop Columns](drop-columns.md): Remove columns from a table permanently. This operation cannot be undone and will result in the loss of all data in t... - [Drop Table](drop-table.md): Drop a table and all its associated data permanently. If the table does not exist, the operation will return 200 with... - [DuckDB](duckdb.md): ## Documentation Index - [Error Handling in Geneva UDFs](error-handling.md): ## Documentation Index - [Evaluating Hybrid Search Performance](eval.md): ## Documentation Index - [LanceDB Cloud FAQ](faq-cloud.md): ## Documentation Index - [LanceDB Enterprise FAQ](faq-enterprise.md): ## Documentation Index - [LanceDB: Frequently Asked Questions](faq-oss.md): ## Documentation Index - [LanceDB Enterprise vs OSS](features.md): ## Documentation Index - [Metadata Filtering in LanceDB](filtering.md): ## Documentation Index - [Full-Text Search (FTS) Index](fts-index.md): ## Documentation Index - [Full-Text Search with SQL](fts-sql.md): ## Documentation Index - [Full-Text Search (FTS)](full-text-search.md): ## Documentation Index - [Gemini](gemini.md): ## Documentation Index - [GenKit](genkit.md): ## Documentation Index - [Get Index Details](get-index-details.md): Get detailed statistics and configuration information for a specific index. This endpoint provides information about ... - [Get query execution plan explanation](get-query-execution-plan-explanation.md): ## Documentation Index - [Get started with LanceDB Cloud](get-started.md): ## Documentation Index - [Get Table Details](get-table-details.md): Get detailed information about a table including schema, statistics, and metadata. This endpoint provides comprehensi... - [Get table index statistics](get-table-index-statistics.md): ## Documentation Index - [Get table statistics](get-table-statistics.md): ## Documentation Index - [Get version for a specific tag](get-version-for-a-specific-tag.md): ## Documentation Index - [GPU-Powered Vector Indexing](gpu-indexing.md): ## Documentation Index - [Deploy Geneva using Helm](helm.md): ## Documentation Index - [Hugging Face](huggingface.md): ## Documentation Index - [Hybrid Search](hybrid-search.md): ## Documentation Index - [IBM watsonx](ibm.md): ## Documentation Index - [ImageBind](imagebind.md): ## Documentation Index - [Client SDKs](index.md): ## Documentation Index - [Insert Data](insert-data.md): Insert data into a table with support for append and overwrite modes. Data must be provided in Apache Arrow IPC strea... - [Insert records into a table](insert-records-into-a-table.md): ## Documentation Index - [Instructor](instructor.md): ## Documentation Index - [Introduction](introduction.md): API reference for LanceDB Cloud with Python, JavaScript, and Rust SDK examples. - [Jina](jina.md): ## Documentation Index - [Kiln AI](kiln.md): ## Documentation Index - [Lance format](lance.md): ## Documentation Index - [LangChain](langchain.md): ## Documentation Index - [Linear Combination Reranker](linear-combination.md): ## Documentation Index - [List all tables](list-all-tables.md): ## Documentation Index - [List all tags for a table](list-all-tags-for-a-table.md): ## Documentation Index - [List all versions of a table](list-all-versions-of-a-table.md): ## Documentation Index - [List indexes on a table](list-indexes-on-a-table.md): ## Documentation Index - [List Indexes](list-indexes.md): List all indices associated with a table including their status and configuration details. This endpoint provides inf... - [List namespaces](list-namespaces.md): ## Documentation Index - [List tables in a namespace](list-tables-in-a-namespace.md): ## Documentation Index - [List Tables](list-tables.md): List all tables in the database with optional pagination support. Returns a paginated list of table names with config... - [LlamaIndex](llamaindex.md): ## Documentation Index - [Materialized Views with UDFs](materialized-views.md): ## Documentation Index - [Merge-Insert (Upsert) Data](merge-insert-upsert-data.md): Perform a merge-insert operation (upsert) on a table by combining insert, update, and delete operations based on matc... - [Merge insert (upsert) records into a table](merge-insert-upsert-records-into-a-table.md): ## Documentation Index - [Modify existing columns](modify-existing-columns.md): ## Documentation Index - [MRR Reranker](mrr.md): ## Documentation Index - [Multimodal Data (Blobs)](multimodal.md): ## Documentation Index - [Multivector Search](multivector-search.md): ## Documentation Index - [Ollama](ollama.md): ## Documentation Index - [OpenAI](openai.md): ## Documentation Index - [OpenCLIP](openclip.md): ## Documentation Index - [Optimize Query Performance](optimize-queries.md): ## Documentation Index - [Pandas and PyArrow](pandas-and-pyarrow.md): ## Documentation Index - [Distributed Job Performance](performance.md): ## Documentation Index - [Phidata](phidata.md): ## Documentation Index - [Polars](polars-arrow.md): ## Documentation Index - [PromptTools](prompttools.md): ## Documentation Index - [Pydantic](pydantic.md): ## Documentation Index - [Quantization](quantization.md): ## Documentation Index - [Query a table](query-a-table.md): ## Documentation Index - [Embeddings: Quickstart](quickstart.md): ## Documentation Index - [Geneva Python SDK](reference.md): ## Documentation Index - [Register a table to a namespace](register-a-table-to-a-namespace.md): ## Documentation Index - [Keeping Indexes Up-to-Date with Reindexing](reindexing.md): ## Documentation Index - [Remove columns from table](remove-columns-from-table.md): ## Documentation Index - [Rename a table](rename-a-table.md): ## Documentation Index - [Rename Table](rename-table.md): Rename a table to a new name. The new table name must be unique within the database and cannot conflict with existing... - [Restore table to a specific version](restore-table-to-a-specific-version.md): ## Documentation Index - [Reciprocal Rank Fusion Reranker](rrf.md): ## Documentation Index - [Scalar Indexes](scalar-index.md): ## Documentation Index - [Schema and Data Evolution](schema.md): ## Documentation Index - [SDK Reference](sdk-reference.md): SDK reference for LanceDB Cloud with Python, JavaScript, and Rust SDK examples. - [Search Data](search-data.md): Perform advanced search queries combining vector search, full-text search, and SQL filtering. This endpoint supports ... - [Security & compliance](security.md): ## Documentation Index - [Sentence Transformers](sentence-transformers.md): ## Documentation Index - [Job and Session Startup Optimizations](startup.md): ## Documentation Index - [Meta Llama Synthetic Data Kit](synthetic-data-kit.md): ## Documentation Index - [PyTorch Integration](torch.md): ## Documentation Index - [Troubleshooting Geneva Deployments](troubleshooting.md): ## Documentation Index - [Update a tag to point to a different version](update-a-tag-to-point-to-a-different-version.md): ## Documentation Index - [Update Column Details](update-column-details.md): Alter the name, type, or nullability of existing columns in a table. This operation allows you to modify column prope... - [Update Data](update-data.md): Update rows in a table using SQL expressions and an optional predicate filter. The update operation modifies existing... - [Update rows in a table](update-rows-in-a-table.md): ## Documentation Index - [Update table schema metadata](update-table-schema-metadata.md): ## Documentation Index - [Updating and Modifying Table Data](update.md): ## Documentation Index - [Vector Indexes](vector-index.md): ## Documentation Index - [Vector Search](vector-search.md): ## Documentation Index - [Versioning and Reproducibility](versioning.md): ## Documentation Index - [Voxel51](voxel51.md): ## Documentation Index - [VoyageAI](voyageai.md): ## Documentation Index