![]() This example ALTER TABLE will rename the order_details table to order_information. new_table_name – The new name of the table.Ĭonsider an example that shows how to rename a table to PostgreSQL using the ALTER TABLE operator.The syntax for renaming a table to PostgreSQL (using ALTER TABLE operator): This PostgreSQL example ALTER TABLE will rename the column with the name notes to order_notes in the order_details table. new_name – The new name for the column.Ĭonsider an example that shows how to rename a column in a PostgreSQL table using the ALTER TABLE operator.table_name – Name of the table to change.Syntax to rename the column in the table to PostgreSQL (using ALTER TABLE operator): ![]() This ALTER TABLE example will delete the column named notes from the table named order_details. SET/DROP DEFAULT These forms set or remove the default value for a column. IF EXISTS Do not throw an error if the view does not exist. newcolumnname New name for an existing column.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |