Can I delete a Field from Data Type?

portnova.ksenia · 2020-06-25T15:45:56.339Z

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

mikeloc · 2020-06-25T17:21:39.896Z

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

portnova.ksenia · 2020-06-25T20:52:27.656Z

Thanks, Mike! Found it

adidastyle · 2020-06-27T19:58:16.444Z

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” .