A database is a collection of data. That may sound overly simplistic but it pretty much sums up what any database is.
A database could be as simple as a text file with a list of names. Or it could be as complex as a large, relational database management system, complete with in-built tools to help you maintain the data.
A database could be as simple as a text file with a list of names. Or it could be as complex as a large, relational database management system, complete with in-built tools to help you maintain the data.
To create a database
- In a Query Editor window, type but do not execute the following code:
CREATE DATABASE TestData
GO - Use the pointer to select the words CREATE DATABASE, and then press F1. The CREATE DATABASE topic in SQL Server Books Online should open. You can use this technique to find the complete syntax for CREATE DATABASE and for the other statements that are used in this tutorial.
- In Query Editor, press F5 to execute the statement and create a database named TestData.
Creating and Selecting a Database
If the administrator creates your database for you when setting up your permissions, you can begin using it. Otherwise, you need to create it yourself:mysql>
CREATE DATABASE menagerie;
Post a Comment