---
title: "PUT /api/DatabaseServer/ExecuteSqlQuery/{databaseName}/{commandText}"
method: PUT
path: "/api/DatabaseServer/ExecuteSqlQuery/{databaseName}/{commandText}"
---

# PUT /api/DatabaseServer/ExecuteSqlQuery/{databaseName}/{commandText}

`PUT /api/DatabaseServer/ExecuteSqlQuery/{databaseName}/{commandText}`

## Path parameters

- `databaseName` string, required
- `commandText` string, required

## Response `default`

not available

- SystemDataDataSet — Represents an in-memory cache of data.
  - `RemotingFormat` integer — Xml = 0 Binary = 1
  - `SchemaSerializationMode` integer — IncludeSchema = 1 ExcludeSchema = 2
  - `CaseSensitive` boolean — Indicates whether comparing strings within the DataSet is case sensitive.
  - `DefaultViewManager` SystemObject[] — Indicates a custom "view" of the data contained by the DataSet. This view allows filtering, searching, and navigating through the custom data view.
  - `EnforceConstraints` boolean — Indicates whether constraint rules are to be followed.
  - `DataSetName` string — The name of this DataSet.
  - `Namespace` string — Indicates the XML uri namespace for the root element pointed at by this DataSet.
  - `Prefix` string — Indicates the prefix of the namespace used for this DataSet.
  - `ExtendedProperties` SystemObject[] — The collection that holds custom user information.
  - `HasErrors` boolean — Indicates that the DataSet has errors.
  - `IsInitialized` boolean
  - `Locale` SystemGlobalizationCultureInfo
    - `CurrentCulture` SystemGlobalizationCultureInfo — recursive
    - `CurrentUICulture` SystemGlobalizationCultureInfo — recursive
    - `InstalledUICulture` SystemGlobalizationCultureInfo — recursive
    - `DefaultThreadCurrentCulture` SystemGlobalizationCultureInfo — recursive
    - `DefaultThreadCurrentUICulture` SystemGlobalizationCultureInfo — recursive
    - `InvariantCulture` SystemGlobalizationCultureInfo — recursive
    - `Parent` SystemGlobalizationCultureInfo — recursive
    - `LCID` integer
    - `KeyboardLayoutId` integer
    - `Name` string
    - `IetfLanguageTag` string
    - `DisplayName` string
    - `NativeName` string
    - `EnglishName` string
    - `TwoLetterISOLanguageName` string
    - `ThreeLetterISOLanguageName` string
    - `ThreeLetterWindowsLanguageName` string
    - `CompareInfo` SystemGlobalizationCompareInfo
      - `Name` string
      - `LCID` integer
      - `Version` SystemGlobalizationSortVersion
        - `FullVersion` integer
        - `SortId` string, guid
    - `TextInfo` SystemGlobalizationTextInfo
      - `ANSICodePage` integer
      - `OEMCodePage` integer
      - `MacCodePage` integer
      - `EBCDICCodePage` integer
      - `LCID` integer
      - `CultureName` string
      - `IsReadOnly` boolean
      - `ListSeparator` string
      - `IsRightToLeft` boolean
    - `IsNeutralCulture` boolean
    - `CultureTypes` integer — NeutralCultures = 1 SpecificCultures = 2 InstalledWin32Cultures = 4 AllCultures = 7 UserCustomCulture = 8 ReplacementCultures = 16 WindowsOnlyCultures = 32 FrameworkCultures = 64
    - `NumberFormat` SystemGlobalizationNumberFormatInfo
      - `InvariantInfo` SystemGlobalizationNumberFormatInfo — recursive
      - `CurrencyDecimalDigits` integer
      - `CurrencyDecimalSeparator` string
      - `IsReadOnly` boolean
      - `CurrencyGroupSizes` integer[]
      - `NumberGroupSizes` integer[]
      - `PercentGroupSizes` integer[]
      - `CurrencyGroupSeparator` string
      - `CurrencySymbol` string
      - `CurrentInfo` SystemGlobalizationNumberFormatInfo — recursive
      - `NaNSymbol` string
      - `CurrencyNegativePattern` integer
      - `NumberNegativePattern` integer
      - `PercentPositivePattern` integer
      - `PercentNegativePattern` integer
      - `NegativeInfinitySymbol` string
      - `NegativeSign` string
      - `NumberDecimalDigits` integer
      - `NumberDecimalSeparator` string
      - `NumberGroupSeparator` string
      - `CurrencyPositivePattern` integer
      - `PositiveInfinitySymbol` string
      - `PositiveSign` string
      - `PercentDecimalDigits` integer
      - `PercentDecimalSeparator` string
      - `PercentGroupSeparator` string
      - `PercentSymbol` string
      - `PerMilleSymbol` string
      - `NativeDigits` string[]
      - `DigitSubstitution` integer — Context = 0 None = 1 NativeNational = 2
    - `DateTimeFormat` SystemGlobalizationDateTimeFormatInfo
      - `InvariantInfo` SystemGlobalizationDateTimeFormatInfo — recursive
      - `CurrentInfo` SystemGlobalizationDateTimeFormatInfo — recursive
      - `AMDesignator` string
      - `Calendar` SystemGlobalizationCalendar
        - `MinSupportedDateTime` string, date-time
        - `MaxSupportedDateTime` string, date-time
        - `AlgorithmType` integer — Unknown = 0 SolarCalendar = 1 LunarCalendar = 2 LunisolarCalendar = 3
        - `IsReadOnly` boolean
        - `Eras` integer[]
        - `TwoDigitYearMax` integer
        - `CurrentEra` integer
      - `DateSeparator` string
      - `FirstDayOfWeek` integer — Sunday = 0 Monday = 1 Tuesday = 2 Wednesday = 3 Thursday = 4 Friday = 5 Saturday = 6
      - `CalendarWeekRule` integer — FirstDay = 0 FirstFullWeek = 1 FirstFourDayWeek = 2
      - `FullDateTimePattern` string
      - `LongDatePattern` string
      - `LongTimePattern` string
      - `MonthDayPattern` string
      - `PMDesignator` string
      - `RFC1123Pattern` string
      - `ShortDatePattern` string
      - `ShortTimePattern` string
      - `SortableDateTimePattern` string
      - `TimeSeparator` string
      - `UniversalSortableDateTimePattern` string
      - `YearMonthPattern` string
      - `AbbreviatedDayNames` string[]
      - `ShortestDayNames` string[]
      - `DayNames` string[]
      - `AbbreviatedMonthNames` string[]
      - `MonthNames` string[]
      - `IsReadOnly` boolean
      - `NativeCalendarName` string
      - `AbbreviatedMonthGenitiveNames` string[]
      - `MonthGenitiveNames` string[]
    - `Calendar` SystemGlobalizationCalendar
      - `MinSupportedDateTime` string, date-time
      - `MaxSupportedDateTime` string, date-time
      - `AlgorithmType` integer — Unknown = 0 SolarCalendar = 1 LunarCalendar = 2 LunisolarCalendar = 3
      - `IsReadOnly` boolean
      - `Eras` integer[]
      - `TwoDigitYearMax` integer
      - `CurrentEra` integer
    - `OptionalCalendars` SystemGlobalizationCalendar[]
      - `MinSupportedDateTime` string, date-time
      - `MaxSupportedDateTime` string, date-time
      - `AlgorithmType` integer — Unknown = 0 SolarCalendar = 1 LunarCalendar = 2 LunisolarCalendar = 3
      - `IsReadOnly` boolean
      - `Eras` integer[]
      - `TwoDigitYearMax` integer
      - `CurrentEra` integer
    - `UseUserOverride` boolean
    - `IsReadOnly` boolean
  - `Site` SystemComponentModelISite
    - `Component` SystemComponentModelIComponent
      - `Site` SystemComponentModelISite — recursive
    - `Container` SystemComponentModelIContainer
      - `Components` SystemObject[]
    - `DesignMode` boolean
    - `Name` string
  - `Relations` SystemObject[] — The collection that holds the relations for this DataSet.
  - `Tables` SystemObject[] — The collection that holds the tables for this DataSet.
  - `Container` SystemComponentModelIContainer
    - `Components` SystemObject[]
  - `DesignMode` boolean

---

[API](https://skmtc.net/fusecp/apis/fusecp-server-service.md) · [All operations](https://skmtc.net/fusecp/apis/fusecp-server-service/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/fusecp/fusecp-server-service/versions/2844439c95a3/schema)