Got it. Thanks. On Thu, Apr 2, 2015 at 11:29 AM, Alan Gates <alanfga...@gmail.com> wrote:
> When someone creates a table in your 'abc' database it should by default > be in '/my/preferred/directory/_tablename_'. However, users can specify > locations for their tables which may not be in that directory. AFAIK > there's no way to prevent that. > > Alan. > > Chen Song <chen.song...@gmail.com> > April 2, 2015 at 8:15 > I have a dumb question on DDL statement "create database" > > Say if I create a database > CREATE DATABASE abc > LOCATION '/my/preferred/directory'; > When later on someone needs to create a table in this database, is there a > way to force the location of the table to be under > /my/preferred/directory? > > I searched around but could not find a way to enforce this. > > > -- > Chen Song > > -- Chen Song