oracle table schema

select * from all_tab_columns where table_name = <your table name> will give you the columsn for a particular table. select * from all_indexes where table_name = <your table name> will give you all the indexes for a particular table select * from all_constraints where table_name = <your table name> will give you constraints.

-----Original Message-----
From: anilcan_at_my-deja.com [mailto:anilcan_at_my-deja.com] Posted At: Friday, November 10, 2000 9:46 AM Posted To: server
Conversation: oracle table schema
Subject: oracle table schema

I am working on a project in vb using Oracle Objects for Ole (OO4O). In this project i need to get the structure (schema) of a table in oracle. I mean the names of columns it contains, the names of indexes on it, types of indexes (unique, pk, cluster etc.), the list of its constraints, and the column list that an index on it has. I understood that OO4O doesnt support this. And i am trying to find them using SQL. But i couldnt find the exact SQL statement. I will be
appreciated if you can help me. Thanks ... NOTE: Other ways rather than SQL will be accepted.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 10 2000 - 16:30:16 CST