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- Chapter 1: create database
- Chapter 2: rename database
- Chapter 3: delete database
- Chapter 4: create table
- Chapter 5: rename table
- Chapter 6: drop table
- Chapter 7: truncate table
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-