Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
Modifying Domains To remove a default value from a column use: ALTER TABLE table_name DROP column_name DEFAULT; 259 You can rename both tables and columns: To rename a table, place the new table name after the RENAME keyword: ALTER TABLE current_table_name RENAME TO new_table_name Renaming Table Elements To rename a column, include both the old and new column names separated by the keyword TO: ALTER TABLE table_name RENAME current_column_name TO new_column_name If you have created custom domains, those domains can be Modifying