Manage Database Properties
Learn how to add, configure, and delete properties in Notion databases to organize and structure your data effectively.
Database properties in Notion are the columns that define the structure and data types of your database. They allow you to organize information consistently and make your data more searchable and actionable. This guide covers how to add, configure, and manage properties effectively.
Understanding Database Properties
Properties define the types of information you can store in each database entry. Common property types include:
- Text - For simple text entries and descriptions
- Select - For choosing from predefined options
- Status - For tracking progress or workflow stages
Adding Properties to Your Database
To expand your database structure, you can add new properties at any time. Each property helps categorize and organize your data in meaningful ways.
In your database view, locate the Add property button at the end of your property row. Click it to open the property creation menu.
A property type menu will appear showing various options. Select Text to create a simple text property. You can see other available types like Number, Select, Multi-select, Date, and more.
Configuring Property Types
After adding a property, you can change its type and configure its settings. This flexibility allows you to adapt your database structure as your needs evolve.
Click on the property type dropdown and select Select to change the property type. Select properties allow you to choose from a predefined list of options.
Switch the property type to Status for tracking workflow stages or progress. Status properties provide visual indicators and are ideal for project management.
Click on the Status property name to open the property configuration panel where you can customize its settings.
In the property settings, update the name field to Project Status to give your property a more descriptive name that matches your use case.
For Select and Status properties, you can configure the available options. Click on the property settings to access these configuration options.
Add option values by typing in the option field. For example, type Select to create a new option for your Select or Status property.
Property types can be changed at any time, but be aware that changing types may affect existing data. For example, switching from Text to Number will only preserve numeric values.
Removing Properties
When properties are no longer needed, you can remove them from your database. This helps keep your database structure clean and focused on relevant information.
In the property settings panel, scroll down to find the Delete property option. Click it to initiate the deletion process.
A confirmation dialog will appear. Click Delete to permanently remove the property and all its data from your database.
The property will be immediately removed from your database view. All data stored in that property will be permanently deleted.
Deleting a property is permanent and cannot be undone. All data stored in that property will be lost. Consider duplicating your database or exporting data before making major structural changes.
Best Practices for Property Management
- Plan your property structure before adding data to avoid frequent restructuring
- Use descriptive property names that clearly indicate the type of information stored
- Choose appropriate property types that match your data and workflow needs
- Regularly review and clean up unused properties to maintain database efficiency
Property Types and Use Cases
Property Type | Best Use Cases | Examples |
---|---|---|
Text | Descriptions, notes, names | Project description, client name |
Select | Categories, priorities, types | Priority level, department, task type |
Status | Workflow stages, progress tracking | To Do, In Progress, Done |
Effective property management is essential for maintaining organized, functional databases in Notion. By understanding how to add, configure, and remove properties, you can create databases that perfectly match your workflow and information needs. Remember to plan your structure carefully and choose property types that align with how you'll use the data.
Filter Database Records
Learn how to create, modify, and delete filters in Notion databases to display specific records based on your criteria.
Use Template Databases
Learn how to create team goal tracking databases using Notion's built-in templates, including configuration of quarters, progress tracking, and team organization.