How to add column

didin

Nov 13, 2023 — 1 min read

In this comprehensive guide, we'll walk you through the process, ensuring you can effortlessly enhance your database structure.

Step 1: Access Table Details

Open your project in Dynobird Online Database Designer.
Locate the table you want to modify and double-click on it to reveal the table details.

Step 2: Add a New Column

Once inside the table details, find the "+" button dedicated to adding columns.
Click on the "+" button, and voila! You now have a new blank column ready for customization.

Step 3: Customize Your Column

Update the Column Name: Give your column a meaningful and descriptive name.
Choose the Column Type: Select the appropriate data type for your column from the available options.
Set as Primary Key: If necessary, designate the column as a primary key to uniquely identify each record.
Specify Not Null: Ensure data integrity by marking the column as "Not Null" if it should always contain a value.
Make it Unique: If your data requires uniqueness, enable the "Unique" option for the column.

Conclusion:

Congratulations! You've successfully added and customized a new column in DynoBird Online Database Designer. This user-friendly process ensures that your database remains flexible and adaptable to your evolving needs.

Loading comment system....

Import design from existing database

Dynobird is a robust tool designed to streamline your database design process. With its ability to import designs from existing databases, you don't need to start from scratch. This guide will walk you through how to extract 'CREATE TABLE' scripts from your database GUI and import them into Dynobird. Extracting

How to Change Your Password in Dynobird

Maintaining the security of your Dynobird account is crucial. One of the best practices is to periodically change your password. Here's a step-by-step guide on how to change your password in Dynobird: Changing Your Password 1. Click on the 'File' menu located in the top menu bar. 2. From the

Creating an Organization in Dynobird

Dynobird provides an efficient workspace for managing your team - the 'Organization'. By creating an organization, you can easily collaborate with your team members. Follow these steps to create a new organization: Creating an Organization 1. Open the 'File' menu located in the top menu bar. 2. Click 'Explore'. You

How to Change Table Header Colors

Customizing the look of your tables in Dynobird can significantly improve your database design process. One such customization option is changing the color of table headers. There are two methods to achieve this: using the color palette in the Home menu for bulk changes, or using the color palette in