SQL: An A-Z Index of the SQL Server 2005 database  

Posted by ReelTym

Aggregate - CREATE AGGREGATE
          - DROP AGGREGATE 
Application Role - CREATE APPLICATION ROLE
                 - ALTER APPLICATION ROLE
                 - DROP APPLICATION ROLE
Assembly - CREATE ASSEMBLY
         - ALTER ASSEMBLY
         - DROP ASSEMBLY
ALTER AUTHORIZATION

BACKUP
BACKUP CERTIFICATE
BEGIN [DIALOG [CONVERSATION]]

Certificate - ALTER CERTIFICATE
            - CREATE CERTIFICATE
            - DROP CERTIFICATE
CHECKPOINT
COMMIT
Contract - CREATE CONTRACT
         - DROP CONTRACT
Credential - CREATE CREDENTIAL
           - ALTER CREDENTIAL
           - DROP CREDENTIAL

Database - CREATE DATABASE
         - ALTER DATABASE
         - DROP DATABASE
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.
DBCC dllname    - Unload a DLL from memory.
DBCC DROPCLEANBUFFERS - Remove all clean buffers from the buffer pool.
DBCC FREE... CACHE  - Remove items from cache.
DBCC HELP        - Help for DBCC commands.
DBCC INPUTBUFFER - Display last statement sent from a client to a database instance.
DBCC OPENTRAN    - Display information about recent transactions.
DBCC OUTPUTBUFFER - Display last statement sent from a client to a database instance.
DBCC PROCCACHE   - Display information about the procedure cache
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. 
DBCC SQLPERF     - Display transaction-log space statistics. Reset wait and latch statistics.
DBCC TRACE...    - Enable or Disable trace flags
DBCC UPDATEUSAGE - Report and correct page and row count inaccuracies in catalog views
DBCC USEROPTIONS - Return the SET options currently active
DBCC deprecated commands
DBCC Undocumented commands
DECLARE
Default - CREATE DEFAULT
        - DROP DEFAULT
DELETE
DENY - DENY Object permissions
     - DENY User/Role permissions
Endpoint - CREATE ENDPOINT
         - ALTER ENDPOINT
         - DROP ENDPOINT
Event - CREATE EVENT NOTIFICATION
      - DROP EVENT NOTIFICATION
EXECUTE
EXECUTE AS
EXISTS - Test for the existence of rows

Fulltext Catalog - CREATE FULLTEXT CATALOG
                 - ALTER FULLTEXT CATALOG
                 - DROP FULLTEXT CATALOG
Fulltext Index - CREATE FULLTEXT INDEX
               - ALTER FULLTEXT INDEX
               - DROP FULLTEXT INDEX
Function - CREATE FUNCTION
         - ALTER FUNCTION
         - DROP FUNCTION

GO
GRANT - GRANT Object permissions
      - GRANT User/Role permissions

IF    - Conditionally execute T-SQL statements.
Index - CREATE INDEX
      - ALTER INDEX
      - DROP INDEX
INSERT
iSQL -U user -P password -i script.sql -o logfile.log

Key - CREATE ASYMMETRIC KEY
    - ALTER ASYMMETRIC KEY
    - DROP ASYMMETRIC KEY
    - CREATE SYMMETRIC KEY
    - OPEN SYMMETRIC KEY 
    - CLOSE SYMMETRIC KEY
    - ALTER SYMMETRIC KEY
    - DROP SYMMETRIC KEY
KILL
KILL QUERY NOTIFICATION
KILL STATS JOB

Login - CREATE LOGIN
      - ALTER LOGIN
      - DROP LOGIN

Master Key - CREATE MASTER KEY
           - ALTER MASTER KEY
           - BACKUP MASTER KEY
           - DROP MASTER KEY
           - RESTORE MASTER KEY
           - ALTER SERVICE MASTER KEY
           - BACKUP SERVICE MASTER KEY
           - RESTORE SERVICE MASTER KEY
Message Type - CREATE MESSAGE TYPE
             - ALTER MESSAGE TYPE
             - DROP MESSAGE TYPE

Partition Function - CREATE PARTITION FUNCTION
                   - ALTER PARTITION FUNCTION
                   - DROP PARTITION FUNCTION
Partition Scheme - CREATE PARTITION SCHEME
                 - ALTER PARTITION SCHEME
                 - DROP PARTITION SCHEME
Procedure - CREATE PROCEDURE
          - ALTER PROCEDURE
          - DROP PROCEDURE

Queue - CREATE QUEUE
      - ALTER QUEUE
      - DROP QUEUE

Remote Service Binding - CREATE REMOTE SERVICE BINDING
                       - ALTER REMOTE SERVICE BINDING
                       - DROP REMOTE SERVICE BINDING

RESTORE - RESTORE DATABASE Complete
          RESTORE DATABASE Partial
          RESTORE DATABASE Files
          RESTORE LOGS
          RESTORE DATABASE_SNAPSHOT 
          RESTORE FILELISTONLY - List database and log files
          RESTORE HEADERONLY - List backup header info
          RESTORE LABELONLY  - Media info 
          RESTORE REWINDONLY - Rewind and close tape device 
          RESTORE VERIFYONLY
REVERT
REVOKE - REVOKE Object permissions
       - REVOKE User/Role permissions
Role - CREATE ROLE
     - ALTER ROLE
     - DROP ROLE
ROLLBACK
Route - CREATE ROUTE
      - ALTER ROUTE
      - DROP ROUTE

Schema - CREATE SCHEMA
       - ALTER SCHEMA
       - DROP SCHEMA
SELECT
SEND
SERVERPROPERTY
Service - CREATE SERVICE
        - ALTER SERVICE
        - DROP SERVICE
SESSION_USER
SESSIONPROPERTY
SET @local_variable
SET
SHUTDOWN
Signature - ADD SIGNATURE
          - DROP SIGNATURE
Statistics - CREATE STATISTICS
           - UPDATE STATISTICS
           - DROP STATISTICS

Synonym - CREATE SYNONYM
        - DROP SYNONYM

Table - CREATE TABLE
      - ALTER TABLE
      - DROP TABLE
      - TRUNCATE TABLE
Transaction - BEGIN DISTRIBUTED TRANSACTION
            - BEGIN TRANSACTION
            - COMMIT TRANSACTION
Trigger - CREATE TRIGGER
        - ALTER TRIGGER
        - ENABLE TRIGGER
        - DISABLE TRIGGER
        - DROP TRIGGER
Type - CREATE TYPE
     - DROP TYPE

UNION
UPDATE
User - CREATE USER
     - ALTER USER
     - DROP USER
USE

View - CREATE VIEW
     - ALTER VIEW
     - DROP VIEW
 
XML Schema Collection - CREATE XML SCHEMA COLLECTION
                      - ALTER XML SCHEMA COLLECTION
                      - DROP XML SCHEMA COLLECTION


Related:
   Microsoft books online - T-SQL Reference: SQL 2000 | SQL 2005 | SQL 2008
   SS64 Discussion forum
   Links to other SQL Server websites, books etc.

This entry was posted on Thursday, November 18, 2010 and is filed under , . You can leave a response and follow any responses to this entry through the Subscribe to: Post Comments (Atom) .

0 comments