An A-Z Index of SQL Server database T-SQL commands

   CREATE AGGREGATE    — Create a user-defined aggregate function.
     DROP AGGREGATE    — Drop a user-defined aggregate function
   CREATE APPLICATION ROLE  — Add an application role to the current database.
    ALTER APPLICATION ROLE  — Change the name, password, or default schema of an application role.
     DROP APPLICATION ROLE  — Remove an application role from the current database.
   CREATE ASSEMBLY     — Upload an assembly that was previously compiled as a .dll file
    ALTER ASSEMBLY     — Alter  the SQL Server catalog properties of an assembly.
     DROP ASSEMBLY     — Remove an assembly and all its associated files from the current database.
    ALTER AUTHORIZATION  — Change the ownership of an entity.
b
   BACKUP              — Backup a  database, transaction log or files/filegroups.
   BACKUP CERTIFICATE  — Export a certificate to a file.
   BCP      — Bulk Copy
   BEGIN [DIALOG [CONVERSATION]]  — 
c
    ALTER CERTIFICATE  — Alter a certificate in the database.
   CREATE CERTIFICATE  — Add a certificate to the database.
     DROP CERTIFICATE  — Remove a certificate from the database.
          CHECKPOINT   — Write all dirty pages to disk.
     DBCC CHECKALLOC   — Check consistency of disk allocation.
     DBCC CHECKCATALOG  — Check catalog consistency.
     DBCC CHECKCONSTRAINTS  — Check integrity of table constraints.
     DBCC CHECKDB     — Check allocation, and integrity of all objects.
     DBCC CHECKFILEGROUP  — Check all tables and indexed views in a filegroup.
     DBCC CHECKIDENT  — Check identity value for a table.
     DBCC CHECKTABLE  — Check integrity of a table or indexed view.
     DBCC CLEANTABLE  — Reclaim space from dropped variable-length columns.
          COMMIT      — Mark the end of a transaction.
   CREATE CONTRACT    — Create a contract in the database.
     DROP CONTRACT    — Drop a contract from the database.
   CREATE CREDENTIAL  — Change  properties of a credential.
    ALTER CREDENTIAL  — Change  properties of a credential.
     DROP CREDENTIAL  — Remove a credential from the server.
d
   CREATE DATABASE   — Create a new database & storage files.
    ALTER DATABASE   — Modify a database, or the database files and filegroups.
     DROP DATABASE   — Remove a database from the server.
          DBCC HELP      —   Help for DBCC commands.
          DBCC deprecated commands  — 
          DBCC Undocumented commands
          DBCC dllname   —   Unload a DLL from memory.
          DECLARE   — 
          DELETE    — Remove  rows from a table.
          DENY Object permissions.
          DENY User/Role   — permissions.
     DBCC DROPCLEANBUFFERS  — Remove all clean buffers from the buffer pool.
e
   CREATE EVENT NOTIFICATION  — Create an event notification trigger.
     DROP EVENT NOTIFICATION  — Remove an event notification trigger from the current database.
          EXECUTE       — Execute a stored procedure or function.
          EXECUTE AS    —  Set the execution context of a session.
          EXISTS        — Test for the existence of rows.
f
     DBCC FREEPROCCACHE     — Remove items from plan cache.
     DBCC FREESESSIONCACHE  — Flush the distributed query connection cache.
     DBCC FREESYSTEMCACHE   — Release all unused cache entries from all caches.
   CREATE FULLTEXT CATALOG  — Create a full-text catalog for the database.
    ALTER FULLTEXT CATALOG  — Create a full-text catalog for the database.
     DROP FULLTEXT CATALOG  — Remove a full-text catalog from a database.
   CREATE FULLTEXT INDEX  — Create a full-text index on  a table.
    ALTER FULLTEXT INDEX  — Change  properties of a full-text index.
     DROP FULLTEXT INDEX  — Remove a full-text index from a table.
   CREATE FUNCTION  — Create a user-defined function.
    ALTER FUNCTION  — Alter a user-defined function.
     DROP FUNCTION  — Remove a user-defined function.
g
          GO  — Send the current batch of T-SQL statements to an instance of SQL Server.
          GRANT Object  — Grant permissions to system objects, database objects.
          GRANT User/Role — Grant permissions to a database user, database role, or application role.
i
          IF     — Conditionally execute T-SQL statements.
   CREATE INDEX  — Create an index on a  table or view.
    ALTER INDEX  — Modify an existing index on a table or view.
     DROP INDEX  — Remove one or more Relational or XML indexes from the current database.
     DBCC INPUTBUFFER  — Display last statement sent from a client to a database instance.
          INSERT  — Add a new row to a table or view.
          Invoke-Sqlcmd   — Run an SQL script (PowerShell/SQLCMD).
          iSQL -U user -P password -i script.sql -o logfile.log
k
   CREATE KEY ASYMMETRIC / SYMMETRIC  — Create a key in the database.
    ALTER KEY ASYMMETRIC / SYMMETRIC  — Change the properties of a key.
     DROP KEY ASYMMETRIC / SYMMETRIC  — DROP a key from the database.
     OPEN KEY SYMMETRIC  — Decrypt a symmetric key and makes it available for use.
    CLOSE KEY SYMMETRIC  — Close one or all symmetric keys open in the current session.
          KILL  — Terminate a user process.
          KILL QUERY NOTIFICATION  — Remove a query notification subscription from the instance.
          KILL STATS JOB  — Terminate an asynchronous statistics update job.
l
   CREATE LOGIN  — Create a SQL Server login account (User).
    ALTER LOGIN  — Change properties of a SQL Server login account.
     DROP LOGIN  — Remove a SQL Server login account.
m
   CREATE MASTER KEY    — Create a database master key.
    ALTER MASTER KEY / ALTER SERVICE MASTER KEY  — Alter properties of a  database master key.
   BACKUP MASTER KEY / BACKUP SERVICE MASTER KEY  — Export the database master key.
     DROP MASTER KEY    — Remove the master key from the current database.
  RESTORE MASTER KEY / RESTORE SERVICE MASTER KEY  — Import a database master key from a backup file.
   CREATE MESSAGE TYPE  — Create a new message type.
    ALTER MESSAGE TYPE  — Change properties of a message type.
     DROP MESSAGE TYPE  — Drop an existing message type.
O
     DBCC OPENTRAN      — Display information about recent transactions.
     DBCC OUTPUTBUFFER  — Display last statement sent from a client to a database instance.
p
   CREATE PARTITION FUNCTION  — Create a partition function in the current database.
    ALTER PARTITION FUNCTION  — Alter the boundary values for a partition function.
     DROP PARTITION FUNCTION  — Drop  a partition function from the current database.
   CREATE PARTITION SCHEME  — Create a partition scheme in the current database.
    ALTER PARTITION SCHEME  — Change the allocation of a NEXT USED filegroup to a partition scheme.
     DROP PARTITION SCHEME  — Drop  a partition function from the current database.
   CREATE PROCEDURE    — Create a stored procedure.
    ALTER PROCEDURE    — Modify a previously created stored procedure.
     DROP PROCEDURE    — Drop one or more stored procedures from the current database.
     DBCC PROCCACHE    — Display information about the procedure cache.
q
   CREATE QUEUE  — Create a message queue.
    ALTER QUEUE  — Change the properties of a message queue.
     DROP QUEUE  — Drop a queue.
r
   CREATE REMOTE SERVICE BINDING  — Define remote service security credentials.
    ALTER REMOTE SERVICE BINDING  — Modify remote service security credentials.
     DROP REMOTE SERVICE BINDING  — Drop a remote service binding.
          RESTORE DATABASE Complete  — Restore  a database from a full  backup.
          RESTORE DATABASE Partial  — Restore parts of a database/point in time.
          RESTORE DATABASE Files   — Restore Files, Filegroups or Pages.
          RESTORE LOGS     — Restore  a Transaction Log.
          RESTORE DATABASE_SNAPSHOT   — Revert to a Database Snapshot.
          RESTORE FILELISTONLY — List data/log files.
          RESTORE HEADERONLY  — List backup header info.
          RESTORE LABELONLY   — Media info.
          RESTORE REWINDONLY  — Rewind and close tape device.
          RESTORE VERIFYONLY  — 
          REVERT     — Switch execution context back to the caller of the last EXECUTE AS statement.
          REVOKE Object     — Revoke permissions on system objects, database objects.
          REVOKE User/Role  — Revoke permissions granted or denied to a database user or role/app role.
   CREATE ROLE    — Create a new database role in the current database.
    ALTER ROLE    — Change the name of a database role.
     DROP ROLE    — Delete a role from the database.
          ROLLBACK — Undo a transaction, completely or to a savepoint.
   CREATE ROUTE   — Add a new route to the routing table for the current database.
    ALTER ROUTE   — Modify properties of a route.
     DROP ROUTE   — Delete a route from the current database.
s
   CREATE SCHEMA  — Create a schema in the current database.
    ALTER SCHEMA  — Transfer a securable between schemas.
     DROP SCHEMA  — Remove a schema from the database.
          SELECT  — Retrieve rows from the database.
          SEND    — Send a message, using an existing conversation.
          SERVERPROPERTY — Display information about the server instance.
   CREATE SERVICE  — Create a new service (a task or set of tasks).
    ALTER SERVICE  — Create a new service (a task or set of tasks).
     DROP SERVICE   — Remove a service from the database.
          SESSION_USER  — Return the user name of the current context in the current database.
          SESSIONPROPERTY  — Display the SET options currently set for a session.
          SET @local_variable  — Set a local variable.
          SET  — 
     DBCC SHOW_STATISTICS  — Display the current distribution statistics.
     DBCC SHRINKDATABASE  — Shrink the size of the database data and log files.
     DBCC SHRINKFILE   — Shrink or empty a database data or log file.
          SHUTDOWN   — Immediately stop SQL Server.
      ADD SIGNATURE  — Add a digital signature to a stored procedure or function.
     DROP SIGNATURE  — Delete a digital signature from a stored procedure or function.
          SQLCMD       — Run a T-SQL statement, procedure or script.
     DBCC SQLPERF      — Display transaction-log space statistics. Reset wait and latch statistics. 
   CREATE STATISTICS   — Create statistics  for one or more table columns in the current database.
   UPDATE STATISTICS   — Update statistics for one or more table columns in the current database.
     DROP STATISTICS   — Drop statistics in the current database.

   CREATE SYNONYM  — Create a synonym.
     DROP SYNONYM  — Remove a synonym.
t
   CREATE TABLE   — Create a new  table.
    ALTER TABLE   — Modify a table definition.
     DROP TABLE   — Remove one or more tables.
 TRUNCATE TABLE   — Remove all rows from a table.
    BEGIN DISTRIBUTED TRANSACTION  — Start a T-SQL distributed transaction.
     DBCC TRACE...     — Enable or Disable trace flags.
    BEGIN TRANSACTION  — Mark the starting point of an explicit, local transaction.
   COMMIT TRANSACTION  — Mark the end of a successful implicit or explicit transaction.
   CREATE TRIGGER — Create a DML or DDL trigger.
    ALTER TRIGGER — Modify the definition of a DML or DDL trigger.
   ENABLE TRIGGER — Enable a trigger.
  DISABLE TRIGGER — Disable a trigger.
     DROP TRIGGER — Remove one or more triggers from the current database.
   CREATE TYPE    — Create an alias data type or user-defined type (CLR) in the current database.
     DROP TYPE    — Remove an alias data type or user-defined type (CLR) from the current database.
u
          UNION   — Combine the results of two or more queries into a single result set.
          UPDATE  — Change existing data in a table.
     DBCC UPDATEUSAGE  — Report and correct page and row count inaccuracies in catalog views.
     DBCC USEROPTIONS  — Return the SET options currently active.
   CREATE USER  — Add a user to the current database.
    ALTER USER  — Rename a database user or change its default schema.
     DROP USER  — Remove a user from the current database.
          USE   — Switch the database context to the specified database or database snapshot.
v
   CREATE VIEW  — Create a View, a virtual table that represents the data in one or more tables.
    ALTER VIEW  — Modify an existing view.
     DROP VIEW  — Remove one or more views from the current database.
x
   CREATE XML SCHEMA COLLECTION  — Import schema components into a database.
    ALTER XML SCHEMA COLLECTION  — Add new schema components to an existing XML schema collection.
     DROP XML SCHEMA COLLECTION  — Delete an entire XML schema collection and all of its components.

To scroll this page, press [ a – z ] on the keyboard, also on the detail pages 's' = syntax 'e' = examples, '\' = Search.

Related commands

Microsoft Transact-SQL reference
SQL Server PowerShell cmdlets
SQL How-To pages
Links to other SQL Server websites, books etc.