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.
Microsoft Transact-SQL reference
SQL Server PowerShell cmdlets
SQL How-To pages
Links to other SQL Server websites, books etc.