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

Reply via email to