Database is a computer application. It is an collection of data. It help us in representing information in the form of table. How to create a SQL database?
Step 1- You need to create a database.
Database holds the group of objects. It acts as a container for these objects. We can store data in form of Table and also we can add Queries. SQL Server Management Studio can help us in the creation of database. Select Start menu then Microsoft SQL Server and finally SQL Server Management Studio.
Step 2- Creation of Table.
It help us in holding the data. You can add new columns and new tables. Table resembles spreadsheet. You can select new table by clicking Tables and then New Table. The size of data type should not be more than 50.
Step 3- You can enter data and view it.
Right click on the Table and then select the option of Open.
