Skip to content

Main NavigationHome Getting Started Guides Reference Tutorials Whitepapers Status

Appearance

Sidebar Navigation

Getting Started

What is MetaKraftwerk?

About Metadata

MetaKraftwerk Tour

Guides

Pattern Development

What is a Pattern?

Integrations

Informatica

Snowflake

Databricks

Azure Synapse

Microsoft Fabric

Creating a pattern

Instance Metadata Schema

File Templates

Modularity

Pattern Versioning

Use Cases

Instance Metadata

Release Management

Deployments

SQL Guide

Basics

Joins

Subqueries

Querying Hierarchical Data

Common Table Expressions (CTE)

Window Functions

Scripting Guide

Blocks

Variables

Returning a value

Conditional logic

Loops

RESULTSETs

Exceptions

Examples / Common Use cases

Reference

General

Introduction

Login / Logout

Project Selection

Read-Only Mode

Application Sections

Profile

Administration

Project Definition

User Management

Pattern Definition

Release Management

Agents

Label Definition

Connections

REST API

Informatica

Azure Synapse Analytics

Microsoft Fabric

Snowflake (SQL)

Snowflake (API)

Salesforce

PostgreSQL

AWS Redshift

GCP BigQuery

Apache Hive

Databricks (SQL)

Databricks (API)

SQL Server

Oracle

MySQL

MariaDB

Db2

Flat File

PowerCenter

Git

Patterns

Documentation

Pattern Upload

Sections

Functional Roles

Instance Properties

Constraints

Datatypes

Files

Reusable Expressions

Deployments

History

Labels

Variables

Editors

File Editor

Reusable Expression Editor

Naming Editor

Port Editor

Expression Editor

Property Editor

Lookup Editor

Instances

Table Editor

Deletion

Historization

Toolbar

Validation

Upload

Moving Columns

Filtering

Download

Release Management

Working

Delete & Restore

Commit graph

Release Group

Merge

Release Selection

Instance Versioning

Adding To Release

Builds

Start of a new build

Build result download

Instance historization

Projects

Delivery reports

Savings analysis

Project level labels

Meta Database

SQL Datatype Reference

SQL Command Reference

Query Syntax

SELECT

WITH

INTO

FROM

CONNECT BY

JOIN

WHERE

GROUP BY

HAVING

ORDER BY

LIMIT

Query Operators

Arithmetic

Comparison

Logical

Set Operators

Subquery

General DDL

CREATE TABLE

ALTER TABLE

DROP TABLE

CREATE VIEW

DROP VIEW

CREATE PROCEDURE

DROP PROCEDURE

COMMENT

General DML

INSERT

MERGE

UPDATE

DELETE

TRUNCATE

Function Reference

ABS

ACOS

ANY_VALUE

ASCII

ASIN

ATAN

ATAN2

AVG

CEIL

CHR

COALESCE

CONCAT

COS

COSH

COUNT

CURRENT_RELEASE

CURRENT_USER

DECODE

DENSE_RANK

EXP

FIRST_VALUE

FLOOR

GREATEST

IN & [NOT] IN

INITCAP

INSTR

IS [NOT] NULL

LAG

LAST_VALUE

LEAD

LEAST

LENGTH

LN

LOG

LOWER

LPAD

LTRIM

MAX

MEDIAN

MIN

MOD

NTH_VALUE

NULLIF

NVL

NVL2

POWER

RANK

REGEXP_INSTR

REGEXP_REPLACE

REGEXP_SUBSTR

REMAINDER

REPLACE

ROUND

ROW_NUMBER

RPAD

RTRIM

SIGN

SIN

SINH

SQRT

SUBSTR

SUM

TAN

TANH

TO_CHAR

TRANSLATE

TRIM

TRUNC

UPPER

Window function syntax and usage

Scripting Reference

BEGIN ... END

BREAK

CASE

CONTINUE

DECLARE

EXCEPTION

FOR

IF

LET

NULL

RAISE

RETURN

WHILE

Information Schema

COLUMNS

COMMITS

DELIVERIES

INSTANCE_LABELS

Instance M etadata

INSTANCES

PATTERN_VARIABLES

TABLES

Tutorials

Azure Synapse Analytics

Informatica + BigQuery

Whitepapers

On this page

Reference>Meta Database>Information Schema

Information Schema

Last updated:

Pager

Previous pageWHILE

Next pageCOLUMNS

© 2025 MetaKraftwerk GmbH. All Rights Reserved.