SQL Manipulate Database

OBJECTIVE

In this chapter you will learn:

How to manipulate database and table
Statements used to manipulating database

 

How to manipulate database and table

If you use SQL server which is a database and support RDBMS then you can also manipulate the database and tables according to you. Suppose that you want to use your own database to save the records then you can create, rename and delete it. You can also create, rename and delete tables but to do these activities you have to use some commands which are given below paragraph.

Statements used to manipulating database

StatementsDescription
create databaseUsed to create database
renameUsed to rename database or table
drop databaseUsed to delete database
create tableUsed to create a table
rename tableUsed to rename table
drop tableUsed to delete table
truncateUsed to delete the records of the table but the columns are not deleted

List of statements used to manipulate database

Statements

SUMMARY

In this chapter we knew that we can create, rename and delete the database and table. In the next chapter we will know the details of each statement with example so click on NEXT button to continue-


Leave a Reply

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