Microsoft SQL Server data provider

Microsoft SQL Server

Object Explorer

Server
    Databases
        System Databases
        Database Snapshots
        <Database>
            Tables
		        System Tables
                <Table>
                    Columns
                    Triggers
                    Indexes
            Views
			    System Views
                <View>
                    Columns
                    Triggers
            Programmability
                Stored Procedures
                    System Stored Procedures
			    Functions
                User-defined Table Types                
                Security
                    Users
                    Roles
                    Schemas
    Security
        Logins
    Server Objects
        Linked Servers
    Jobs

Object Explorer - Table node

How to script table to clipboard?

1. Right click to table
2. Script table as CREATE/SELECT/INSERT to clipboard.

Query textbox – code completion

How to list databases

1. Type use and press Crlt+J (List members)

How to list tables, views, functions in a database

1. Type select * from and press Ctrl+J

How to list columns of a table

1. Type select * from where . and press Ctrl+J

   How to list stored procedures, functions

   1. Type exec and press Ctrl+J

   How to list the distinct top 10 field values of a column

   1. Type select * from
   where . = and press Ctrl+J

   How to list global variables

   1. Type select @@ and press Ctrl+J

   How to list local variables

   1. Type select @ and press Ctrl+J