Subject | Select Query for show table |
---|---|
Author | karthick srini |
Post date | 2004-09-29T06:12:37Z |
Dear Members,
In "ISQL" there is a command "show table
<table_name>" it will detail the table description
(column names type , FK , PK etc).
Is Similarly functionality can be achieved in Select
SQL i.e. "Select .. from ..."
In our Java application I need this functionality.
So please do provide me the equivalent Select query to
get the table description,
Thanks & Regards,
S.Karthick
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
In "ISQL" there is a command "show table
<table_name>" it will detail the table description
(column names type , FK , PK etc).
Is Similarly functionality can be achieved in Select
SQL i.e. "Select .. from ..."
In our Java application I need this functionality.
So please do provide me the equivalent Select query to
get the table description,
Thanks & Regards,
S.Karthick
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com