Hi I have created One view... But I want to see the table details which i used in this view... Can anyone help this.
Printable View
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.