When was schema created?

Moderator: NorbertKrupa

Post Reply
sarah
Intermediate
Intermediate
Posts: 77
Joined: Mon Aug 27, 2012 1:34 pm

When was schema created?

Post by sarah » Mon Apr 21, 2014 3:29 pm

Hi,

Is there a way to find out when a schem was created?

Thanks!
Have a GREAT day!
Top
scutter
Master
Master
Posts: 302
Joined: Tue Aug 07, 2012 2:15 am

Re: When was schema created?

Post by scutter » Mon Apr 21, 2014 3:46 pm

The SCHEMATA table has a create_time column.

—Sharon
Sharon Cutter
Vertica Consultant, Zazz Technologies LLC
Top
sarah
Intermediate
Intermediate
Posts: 77
Joined: Mon Aug 27, 2012 1:34 pm

Re: When was schema created?

Post by sarah » Tue Apr 22, 2014 1:57 pm

Thank you, scutter!
Have a GREAT day!
Top
Post Reply

Return to “Vertica Database Administration”