Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • SQL Database

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 110
    Comment on it

    SQL Create statement is used to create a database .
    Syntax

    create database databaseName ;
    

    Now if you wanna to add tables in that database then first you have to use that databse using USE DATABASE_NAME and then use create table statement .

    Now If you want to Drop Database then using SQL Drop statement you can easily delete or remove indexes from the table in the database .
    Syntax

    Drop Database DatabaseName ;
    

    Note -> If you delete or drop the database using this statement then all the tables and views will also be deleted . SO be careful while using this statement .

    How to Rename the Database ?
    Once creating database and then you want to Rename the database name then by using SQL Rename statement you can easily changed the name of the existing database .
    Syntax >

    Rename Database **oldDatabaseName** To **newDatabase-name** ; 
    

    How to Select a current Database ?
    Using SQL select statement you can select any database and can perform the task whatever you want like retreive information , update some information into the database etc . Or suppose you want to retrieve the information from specified column from a table then you can also do with this statement .
    Syntax ->

    Select col-name From table-name [ where clause ] or [ Group by clause ] or [ having clause ] or [ order by clause ] ; // you can use all these clause with select statement to perform some specific task 
    

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: