How to Create a new Database – Sql Server Tutorial


To create a new db in an object explorer select databases -> right click  -> SSMS ->Select ->new data base ->Object explorer side ->Server(SQL server 9.0.1399-sa) ->it is a instance ->Database ->Right click and  Select ->New db

In New DB:

Enter DB Name   : DB6PM

  • At the time of creating DB sql server mainly creates two files, one file is called “data file” and second file is called “log file”
  • The data file contains “actual data” and log file contains “operations performed over DB”

In sql server database is a collection of objects.

DB6PM  [it is a new DB Name] Contains below:

  • Tables
  • Views
  • Synonyms
  • Indexes
  • Indexed views

The above five objects comes under Non procedural part

  • Procedures
  • Functions
  • Triggers

These Three comes under procedural part 

How to open the Database:–

  • Select the Database
    • Right click
    • Select
    • Select new query

How to delete the DB :–

  • Select the database
  • Right click
  • Select
  • Delete

Leave a Reply

Your email address will not be published. Required fields are marked *