Can I delete a Field from Data Type?

How can I delete a Field (column) from a Data Type (table) in my database?
Thanks.

1 Like

Hi there, @portnova.ksenia… yes, you can delete a field from a data type. Go to the Data area and select the Data types tab. Click on the data type that includes the field you want to delete, and you will see the fields associated with the selected data type on the right-hand side of the screen. To the far right of each field is a trash can icon that enables you to delete the field.

Hope this helps.

Best…
Mike

2 Likes

Thanks, Mike! Found it :slight_smile:

ALTER “TABLE” table_name DROP “COLUMN” column_name; In this syntax: First, specify “the” name of “the table” from which you want to “delete the column” . Second, specify “the” name of “the column” that you want to “delete” .

1 Like