distal-attribute
distal-attribute
distal-attribute
distal-attribute

How to add a field name to existing database?

surgey46 posted 4 years ago in General
Hi, I am new to this, I need to add just one field to my existing database, like for example "name" . Could you tell how this can be done. Thanks in advance.
ansgar posted 4 years ago
Databases do not have fields, tables do. In order to add columns, just double click the relevant table and click the "Add" button.
surgey46 posted 4 years ago
How to create a table?
surgey46 posted 4 years ago
And I forgot also to ask, how to specify table name after creating it, also I need just one column for this table for example "IP".
The column name would be "IP_Id".
waiting for replay...
member posted 4 years ago
Click on the database name on the left, then click on the third tab on the right labeled table.

Choose add, use the dropdown choices on the line it opens up.

Just a guess you can probably use datatype int, length 11, no checkmarks and auto increment (if you want each id to be the next available number)

member posted 4 years ago
Click on the third tab on the right labeled table. Table name is below all of the tabs but above the add button.

Remember to hit save when adding a row and when renaming the table. You can make all needed changes and then hit save.
surgey46 posted 4 years ago
Finally I created table in my database. I named column also.
How would I add data to my table?
ansgar posted 4 years ago
When you have your table doubleclicked / selected, you will see a Data tab right besides the active Table tab. Go to the Data tab and press Ins to add the first row.

Please login to leave a reply, or register at first.