Common SQL statements

This topic describes common SQL statements in MaxCompute.

MaxCompute allows you to perform operations on objects, such as projects, tables, resources, and instances. You can use tools or the MaxCompute SDK to perform operations on these objects.

Note For more information about the MaxCompute SDK, see MaxCompute SDK.

The following table describes common SQL statements in MaxCompute.


Operation category	Common statement
Project operations	Enter a project (use) View project properties (setproject) Configure project properties (setproject) View account systems of a project (list accountproviders) Add the RAM account system (add) Remove the RAM account system (remove)
SET operations	SET show flags
Security operations	Enable project data protection (ProjectProtection) Add a trusted project (add trustedproject) Remove a trusted project (remove trustedproject) View trusted projects (list trustedprojects) View the security configurations of a project (show SecurityConfiguration)
User and role operations	Add a user (add user) Remove a user (remove user) View users (list users) Create a role (create role) View roles (list roles) Grant a role to a user (grant) Revoke a user from a role (revoke) Delete a role (drop role)
Authorization operations	Grant a role or user (grant) Revoke role or user permissions (revoke)
Table operations	Create a table (create table) Change the owner of a table (alter table) Delete a table (drop table) View the information of a table or view (desc) View the information of a partition (desc partition) List tables (show tables) List partitions (show partitions)
Partition and column operations	Add partitions (alter table add) Delete partitions (alter table drop) Add columns or comments (alter table add columns) Change the name and comment of a column (alter table change column)
Instance operations	View instance information (show) Query instance status (status) View information of running instances (top instance) Stop an instance (kill) Obtain job information of an instance (desc) Obtain the operational log of jobs in an instance (wait)
Resource operations	Add resources (add) View information of all resources (list) Create an alias for a resource (alias) Download a resource (get) Delete a resource (drop)
Function operations	Create a function (create function) Delete a function (drop function) View a function (desc function) View the function list (list functions)
Tunnel operations	Upload data (Tunnel upload) Download data (Tunnel download)
Time zone configuration operations	Time zone configuration operations
Other operations	Cost estimation (cost sql)

Usage notes

Keywords, project names, table names, and column names in MaxCompute SQL statements are not case sensitive.