select * from <table_name> where 1=2

Hi,
I am working on a java application and i have to caplture the table structure if the tables in my database by using select * from <tablename> where 1=2. But this is a fulltable scan.Is there any other method by which i can capture the table structures without doing a full table scan.I tried select * from <table_name> where rownum= -1.when i tried this with set timing on .This takes more time than select ...1=2.. Please suggest some way.

anurag

reply at
anurag_at_synergy-infotech.com Received on Mon Jul 05 1999 - 22:29:04 CDT