IBM PureData System for Analytics, Version 7.1

Change table ownership

If you are the owner of the table or have the Alter privilege on tables, you can change the owner of a table without changing any of its data. The new owner must be a current system user.

To change the owner of a table, enter:
   MYDB.SCHEMA(USER)=> ALTER TABLE weather OWNER TO jane;


Feedback | Copyright IBM Corporation 2014 | Last updated: 2014-02-28