How to see the metadata of objects in Vertica Database (desc like Oracle)

ddl vertica
Up_One picture Up_One · Jul 13, 2012 · Viewed 13.6k times · Source

I would like to know how I can get the metadata of an object in a Vertica database; like metadata of a table. Is there any table that stores the metadata of objects (functions, views, tables) in Vertica Database.
For example in Oracle, I could type the following and get a detailed description of tables or see the code of a procedure.
oracle :> desc table_name;
or
oracle :> edit proc_name;

I know that I can see the tables from my schemas with \dt command, but is there any way I can see the DDL statements that created the objects?

Answer

Up_One picture Up_One · Jul 18, 2012

Thanks, but this is not what I want. I was looking for is the export_objects() function:

select export_objects('','object_name')

This way you will get the creation script for the object.

Related questions

How to delete a column from a table in MySQL

Given the table created using: CREATE TABLE tbl_Country ( CountryId INT NOT NULL AUTO_INCREMENT, IsDeleted bit, PRIMARY KEY (CountryId) ) How can I delete the column IsDeleted?

Read More
Adding multiple columns AFTER a specific column in MySQL

I need to add multiple columns to a table but position the columns after a column called lastname. I have tried this: ALTER TABLE `users` ADD COLUMN ( `count` smallint(6) NOT NULL, `log` varchar(12) NOT NULL, `status` int(10) unsigned NOT NULL ) …

Read More
What are DDL and DML?

I have heard the terms DDL and DML in reference to databases, but I don't understand what they are. What are they and how do they relate to SQL?

Read More