Search found 302 matches

by nnani
Fri Apr 13, 2012 7:11 am
Forum: New to Vertica
Topic: How to copy a table with no data?
Replies: 6
Views: 17708

Re: How to copy a table with no data?

Hi Josh,

As per my understanding you requirement is to just copy the table structure

Hope this query can help you:

create table foo_new as select * from foo limit 0;

Let me know if this helps you.

Go to advanced search