Refuse to drop the column or constraint if there are any dependent objects. The role name of the new owner of the external table.Īutomatically drop objects that depend on the dropped column, such as a view that references the column. The name (possibly schema-qualified) of an existing external table definition to alter.ĭata type of the new column, or new data type for an existing column. To modify this information, you must drop and recreate the external table definition. The ALTER EXTERNAL TABLE and ALTER TABLE commands cannot modify the type of the external table (read, write, web), the table FORMAT information, or the location of the external data. A superuser has these privileges automatically.Ĭhanges that you make to an external table definition with either ALTER EXTERNAL TABLE or ALTER TABLE do not affect the external data. To alter the owner, you must also be a direct or indirect member of the new owning role, and that role must have CREATE privilege on the external table's schema. To change the schema of an external table, you must also have CREATE privilege on the new schema. You must own the external table to use ALTER EXTERNAL TABLE or ALTER TABLE.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |