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-

More Articles

 

Share your thought



PLEASE DISABLE ADBLOCKER AND SUPPORT US!

Please support us by enabling ads on this page. Refresh

YOU DON'T LIKE ADS, WE ALSO DON'T LIKE ADS!
 
But we have to show ads on our site to keep it free and updated. We have to pay huge server costs, domain costs, CDN Costs, Developer Costs, Electricity and Internet Bill. Your little contribution will encourage us to regularly update this site.