Column names can't be duplicated in a table.Įvery table has a primary key column, that uniquely identifies the data in the table. The table is one of the primary components of a relational database.Įach table is made up of columns and rows.Ĭolumns are defined to hold a specific type of data such as numeric, dates or text. The next step is to populate the database with tables and data.įirst of all, what is a table? A database table is where all the data in a relational database is stored. Make sure Public is selected, and click Ok. A new dialogue box will appear, asking you to create a new file for your database.Īfter you created the new file, click on Connect.Ī new dialogue box will appear. In the Database section, click on Create new. If not, click on the dropdown menu and select File. In the Method & Driver field, the File driver should be selected. In the RDBMS field, choose the H2 option. You can choose whatever name you like, but for this tutorial, we recommend that you stick with H2. The Alias field is used for naming your database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |