How to Drop Database

Drop Database by Wizard
 - Click on Databases

• Choose one of Database name that you want to delete
• See image below

- After you click on Detele

Create New Table in SQL Server 2008

Create New Table by Wizard
 This is a way to create Table in SQL Server 2008. Please, follow the step

- Click on Database which we created
    . Choose Table
      + Right Click on Table Choose "New Table"














  



     + It shows structure of Table such as ColumnName, Data Type, and Allow Nulls
        - ColumnsName is field which we put the name of colunms in table
          Ex: StudentID, Name, Sex,YOB................................etc.
        - Data Type is field which choose type ot data for column
         Ex: nvarchar,int ,nvarchar.........etc.
        - Allow Nulls is the permission for column when we created it we want those column Null or not Null depend on Creater
please, see picture below

  



   


   +  Put the Name for New Table
          - Ex: New Tale : TblStudentInformation

 


    +  Finished

Create New Table by TSQL
- Sytax: Create Table TableName(ColumnsName1 DataTye PRIMARY KEY CLUSTERED ,ColumnsName2 DataTye,................................)

- See Example below:

How to create Database In SQL Server 2008

Create Database By Wizard

This is a way to create Database SQL Server 2008 . Please follow those step

- Click  Start to Open SQL Server Management Studio.

It shows Dialog Box

 - Click Databases
   . Choose New Database























- After Please put the name for database
  . Ex: Database name: Student Management

- See the result

Create Database by TSQL
- Sytax: Create Database DatabaseName;
    Ex:  Create database StudentInformation;




















Note: You can choose one of the way to create database which you think that easy for you


More detail about this Please contact to my E-mail: sothea_kits@yahoo.com