---
title: "Formatted SQL Field"
slug: "formatted-sql-field"
updated: 2026-06-24T18:59:41Z
published: 2026-06-26T13:43:01Z
canonical: "skthelp.syniti.com/formatted-sql-field"
stale: true
---

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

# Formatted SQL Field

### Overview

In legacy Construct, Text Area fields could be configured with **SQL** format that provided syntax highlighting and formatting for SQL text display. The Formatted SQL field feature was specifically used by:

- Admin and metadata management pages
- Pages displaying stored procedures, views, or query definitions

Cloud Construct does not have built-in SQL syntax highlighting, but you can display SQL as a read-only plain text in a multi-line Text Area field.

### Updated Methodology

In Cloud Construct, formatted SQL display is not available. To allow users to view SQL statements (as plain texts) without editing:

1. Ensure the dataset column stores the SQL statement as text (nvarchar or nvarchar(max) for long queries).
2. Edit the required WebApp.
3. In the WebApp Builder, configure the column as a **Text Area** input type to support multi-line display.
4. Disable **Support Update** and **Support Delete** toggles to set the column as **read-only**. So users cannot modify the SQL.
5. Save and Preview the WebApp.

The field displays SQL as plain text in a multi-line text box. Users can read and copy the SQL for use in SQL Editor or external tools, for example, SSMS.

### Related Articles

[Column Base Properties](/v1/docs/configure-column-properties#column-input-types)