SQL Manipulate Database

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

Statements Description
create database Used to create database
rename Used to rename database or table
drop database Used to delete database
create table Used to create a table
rename table Used to rename table
drop table Used to delete table
truncate Used 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 the example so click on NEXT button to continue-

 

Share your thought