How to check the List of columns in a table for particular schema ???
+1How to check the List of columns in a table for particular schema ??? The below Oracle query is not working with HP Vertica: select COLUMN_NAME from ALL_TAB_COLUMNS where table_name= and owner= Vertica is not giving support for ALL_TAB_COLUMNS
+2I believe I've addressed this in response to your other post at https://community.vertica.com/vertica/topics/how_to_check_the_list_of_tables_in_particular_schema_in_hp_vertica Let us know if you have further questions. Adam
+2Hello Syed, Select column_name from columns where table_name='tableA' and owner_name='syed'; Hope this helps.
Make that:
select column_name from columns where table_name = 'tableA' and table_schema='syed';
select column_name from columns where table_name = 'tableA' and table_schema='syed';
If I want the entire table structure of a particular table ?
Hi Krishna,
You can use below for vsql.
\d tables_schema.table_name
you can get ddl of a table using
select export_objects('','table_schema.table_name');
You can use below for vsql.
\d tables_schema.table_name
you can get ddl of a table using
select export_objects('','table_schema.table_name');
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
