Create data base

To Create the database using a query
Create database DatabaseName


Whether, you create a database graphically using the designer or, using a query, the following 2 files gets generated.
.MDF file - Data File (Contains actual data)
.LDF file - Transaction Log file (Used to recover the database)


To alter a database, once it's created 
Alter database DatabaseName Modify Name = NewDatabaseName


Alternatively, you can also use system stored procedure
Execute sp_renameDB 'OldDatabaseName','NewDatabaseName'


To Delete or Drop a database
Drop Database DatabaseThatYouWantToDrop


Dropping a database, deletes the LDF and MDF files.

Comments

Post a Comment

Popular posts from this blog

Prime Number Program in C#

Prime number is a number that is greater than 1 and divided by 1 or itself. In other words, prime numbers can't be divided by other numbers than itself or 1. For example 2, 3, 5, 7, 11, 13, 17, 19, 23.... are the prime numbers. using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace ConsoleApplication1 {     class Program     {         static void Main(string[] args)         {             int number, i, m = 0, flag = 0;             Console.WriteLine("PLEASE ENTER THE NUMBER TO CHECK PRIME NUMBER");             number = int.Parse(Console.ReadLine());             m = number / 2;             for(i=2;i<=m;i++)             {           ...
Read more

Fibonacci Series in C#

In the case of Fibonacci series, the next number is the sum of the previous two numbers for example 0, 1, 1, 2, 3, 5, 8, 13, 21 etc. The first two numbers of Fibonacci series are 0 and 1. using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace ConsoleApplication1 {     class Program     {         static void Main(string[] args)         {             int val1 = 0, val2 = 1, val3, i, number;             Console.WriteLine("Please Enter any number");             number = int.Parse(Console.ReadLine());             Console.WriteLine(val1 + " " + val2);             for (i=2;i<=number;i++)             {                 val3 =...
Read more

Joins in SQL server

Image
In SQL server, there are different types of JOINS. 1. CROSS JOIN 2. INNER JOIN  3. OUTER JOIN  Outer Joins are again divided into 3 types 1. Left Join or Left Outer Join 2. Right Join or Right Outer Join 3. Full Join or Full Outer Join Now let's understand all the JOIN types, with examples and the differences between them.   Employee Table (tblEmployee)   Departments Table (tblDepartment) SQL Script to create tblEmployee and tblDepartment tables Create   table  tblDepartment (      ID  int   primary   key ,      DepartmentName  nvarchar ( 50 ),      Location  nvarchar ( 50 ),      DepartmentHead  nvarchar ( 50 ) ) Go Insert   into  tblDepartment  values  ( 1 ,   'IT' ,   'London' ,   'Rick' ) Insert   into  tblDepartment  values  ( 2 ,   'Payroll' ,   'Delhi' , ...
Read more