drop table member

Allocate this line and press f5. The table will be removed, on what you and will notify. In our case this procedure is simple. Actually in the big DB is simple so to remove the table will fail, as she will be connected to other tables, and for removal{distance} it is required to tear off these communications{connections}. As it to make see the following steps.

How to create the table with the help sql server enterprise manager

Open consistently: sql server group, <yours sql server>, databases. Choose a DB (sqlstepbystep, I think:), press the right button of the mouse and choose in the contextual menu item{point} "new", and then item{point} " table... ". First of all you will ask a name of the table. Enter it{him} and press enter. On the screen the window in which it is possible to enter will appear:

Names of columns, type, length, dimension, accuracy (these three columns are blocked depending on type), a flag of the sanction null, a default value. Last three columns, yet do not represent interest.

Enter names of columns, their type and length as well as in an example is higher. Press an icon with a diskette for preservation of the table and can close a window. Open your DB, click on a category "tables" and in the list of tables will see just the entered table. For its{her} removal{distance} allocate her{it} in the list, press the right button of the mouse and in the contextual menu choose "delete". The table will be removed.

We have studied as are created and udaljutsja tables. Following our step - creation of a high-grade DB by the example of which we shall study:

What is the relational integrity of a DB and as she is provided in sql server

How to modify the data in tables (operators insert, update, delete, select)

How to use stored{kept} procedures and triggers