Run queryRun a T-SQL query and return its rows. Use %(name)s placeholders with 'Parameters' for any value that comes from data. The login's permissions decide what it can touch.
Run statementRun an INSERT, UPDATE, DELETE, MERGE or DDL statement (such as CREATE VIEW) and get the number of rows it changed. Use %(name)s placeholders with 'Parameters' for values.
Run stored procedureRun a stored procedure with named arguments and return every result set it produces plus its return value.
Get server infoThe server's edition and version, the connected database and the login in use. The quickest way to check the connection.
List databasesThe databases the login can see, with state and recovery model. On Azure SQL Database this is the connected database and master only.
List schemasThe schemas in the connected database.
List tablesThe tables the login can see, optionally in one schema.
List viewsThe views the login can see, optionally in one schema.
List columnsA table's or view's columns in order, with type, length, nullability and default.
List indexesA table's indexes with their key and included columns, and its primary key columns.
List stored proceduresThe database's own stored procedures, optionally with each one's parameters.
Select rowsRead rows from a table without writing SQL: choose columns, match on values, sort and page. A limit always applies.
Count rowsHow many rows in a table match the given values.
Insert rowAdd one row to a table and get back its new identity value, if the table has an identity column.
Insert rowsAdd up to 1,000 rows in one go, all or nothing. A column missing from a row is stored as null.
Update rowsChange columns on the rows matching the given values. At least one match is required.
Delete rowsRemove the rows matching the given values. At least one match is required.
Upsert rowUpdate the row with the same key, or insert it if there is none. The key defaults to the table's primary key.
Create tableCreate a table from a list of columns. By default an existing table of that name is left alone.
Drop tableDelete a table and every row in it. This cannot be undone.
