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.

1

In your database view, locate the Add property button at the end of your property row. Click it to open the property creation menu.

Screenshot for Access the Add Property Option
2

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.

1

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.

Screenshot for Switch to Select Property Type
2

Switch the property type to Status for tracking workflow stages or progress. Status properties provide visual indicators and are ideal for project management.

Screenshot for Configure Status Property
3

Click on the Status property name to open the property configuration panel where you can customize its settings.

Screenshot for Access Property Settings
4

In the property settings, update the name field to Project Status to give your property a more descriptive name that matches your use case.

5

For Select and Status properties, you can configure the available options. Click on the property settings to access these configuration options.

6

Add option values by typing in the option field. For example, type Select to create a new option for your Select or Status property.

Screenshot for Add Property Options

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.

1

In the property settings panel, scroll down to find the Delete property option. Click it to initiate the deletion process.

Screenshot for Access Delete Option
2

A confirmation dialog will appear. Click Delete to permanently remove the property and all its data from your database.

Screenshot for Confirm Deletion
3

The property will be immediately removed from your database view. All data stored in that property will be permanently deleted.

Screenshot for Verify Property Removal

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.