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