I want to see the table details

Hi I have created One view... But I want to see the table details which i used in this view... Can anyone help this.

hello ,

if you r using MYSQl or SQL Server then write this query in brouser
> desc <table name> or describe <table name>, it will display description about field.
>show tables (it will display list of tables only in MYSQL)
> Select * from tab(it will display list of tables only in Oracles)

Thnaks
Samir

if your view contains all the fields of the base table , then the structure of the table and the view will be same.
i can use DESCRIBE to get it.

Helo,

If u want to see the details of the table.
Select * from <Table Name>;

Thnx
Saleem

dear saleem he is asking for table details (structure) not the data.