Popular Posts

  • Retrieving the data posted to a JSP file from HTML file
    Now I will show you how to retrieve the data posted from a HTML file in a JSP page. Consider an html page that prompts the user to enter his...
  • Accessing the Standard CGI Variables
    Accessing the Standard CGI Variables: To build the successful web application, you often need to know a lot about the environment in which ...
  • INTRODUCTION TO C
    INTRODUCTION TO 'C': C is a programming language developed at AT & T's Bell laboratories of USA in 1972.it was designed by d...
  • SQL ALIASES
    SQL aliases can be used with database tables and with database table columns, depending on task you are performing. SQL column aliases are u...
  • Learning about Events (Continue)
    Learning about Events (Continue) Lets program the Form_Load event. "MsgBox" is Visual Basic command that launch a message box. for...
  • Exercise 11.3: Polymorphism
    Steps to follow: 1. Write Person.java as shown below in Code-11.3.a under polypackage directory. (You are welcome to do this work using eit...
  • The Command Button's KeyPress, KeyDown and KeyUp Events
    The Command Button's KeyPress, KeyDown and KeyUp Events The events that will be mentioned in the following pages are commonly used, and ...
  • SQL AVG
    The SQL AVG aggregate function selects the average value for certain table column. Have a look at the SQL AVG syntax: SELECT AVG(Column1) FR...
  • INTERFACES EXAMPLES
    package interfaceexercise; // Define an interface with three abstract methods. // Any class that implements this interface has to // impleme...
  • SQL LIKE
    We will use the Customers table to illustrate the SQL LIKE clause usage: FirstName LastName Email DOB Phone John Smith John.Smith@yaho...

Wednesday, March 18, 2009

Manage the Databases

If you expand the node "Databases" on the management studio, you will see the following sub nodes:

System Databases
Database Snapshots

You can expand the System Databases node further to see all the default, system databases. You may not want to mess with them !

Below the System Databases and Database Snapshots, you will see the list of the databases you have created. You can expand any of your database name to see further options below the node. See the screenshot:





Above screen shot shows two custom databases with the names "dotnetspider" and 'aspspider".

Under the database name, you may expand the "Tables" node to see the list of all tables within the selected database.
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)