Skip to content

Presto 0.289 Documentation

SHOW COLUMNS

Initializing search

Presto 0.289 Documentation

Overview
Installation
Presto Clients
Security
Administration
Cache
Query Optimizer
Connectors
Plugins
Functions and Operators
SQL Language
SQL Statement Syntax
SQL Statement Syntax
- ALTER FUNCTION
- ALTER SCHEMA
- ALTER TABLE
- ANALYZE
- CALL
- COMMIT
- CREATE FUNCTION
- CREATE ROLE
- CREATE SCHEMA
- CREATE TABLE
- CREATE TABLE AS
- CREATE VIEW
- DEALLOCATE PREPARE
- DELETE
- DESCRIBE
- DESCRIBE INPUT
- DESCRIBE OUTPUT
- DROP FUNCTION
- DROP ROLE
- DROP SCHEMA
- DROP TABLE
- DROP VIEW
- EXECUTE
- EXPLAIN
- EXPLAIN ANALYZE
- GRANT
- GRANT ROLES
- INSERT
- PREPARE
- RESET SESSION
- REVOKE
- REVOKE ROLES
- ROLLBACK
- SELECT
- SET ROLE
- SET SESSION
- SHOW CATALOGS
- SHOW COLUMNS SHOW COLUMNS
  Table of contents
  - Synopsis
  - Description
- SHOW CREATE FUNCTION
- SHOW CREATE TABLE
- SHOW CREATE VIEW
- SHOW FUNCTIONS
- SHOW GRANTS
- SHOW ROLE GRANTS
- SHOW ROLES
- SHOW SCHEMAS
- SHOW SESSION
- SHOW STATS
- SHOW TABLES
- START TRANSACTION
- TRUNCATE
- UPDATE
- USE
- VALUES
Migration
REST API
Ecosystem
Router
Developer Guide
Presto C++
Release Notes

View Page Source
Edit this page
Create docs issue
Create project issue

Table of contents

Synopsis
Description

SHOW COLUMNS¶

Synopsis¶

SHOW COLUMNS FROM table

Description¶

List the columns in table along with their data type and other attributes.

Previous SHOW CATALOGS

Next SHOW CREATE FUNCTION

© Copyright The Presto Foundation. All rights reserved. Presto is a registered trademark of LF Projects, LLC.