CREATING A NEW DATABASE:
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