|
View previous topic :: View next topic
|
| Author |
Message |
Kamakshi Ayyadurai
New User
Joined: 28 Dec 2007
Posts: 4
Location: Chennai,India
|
|
|
|
Hi Everyone,
I am very Happy  to say that this is my first Post in this Forum. So i decided to post something simple,useful and also cool
Sometimes we try to know the column names in the catalog tables without even intrested in the rows present.
In those times it is not necessary to query the catalog tables but its enough if u refer the poster attached below |
|
| Back to top |
|
 |
vini_srcna
Active User
Joined: 26 May 2005
Posts: 178
Location: Copenhagen, Denmark
|
|
|
|
Good one but not efficient.
Instead of opening, put ZOOM and search for the table, Just a DRAW command in QMF will give you the column names without executing it.
There could be better tools for this as well. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
Give any wrong condition such as
| Code: |
SELECT * FROM Table name
where 1=2
WITH UR; |
You'll get the columns name. |
|
| Back to top |
|
|
|
|
