Results 1 to 5 of 5

Thread: I want to see the table details

  1. 07-06-2007 #1
    ramesh_resides
    ramesh_resides is offline
    Junior Member
    Join Date
    Mar 2007
    Answers
    2

    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.

    Reply With Quote Reply With Quote
  2. 07-07-2007 #2
    ksamir2004
    ksamir2004 is offline
    Junior Member
    Join Date
    Sep 2006
    Answers
    6

    Re: I want to see the table details

    hello ,

    if you r using MYSQl or SQL Server then write this query in brouser
    > desc or describe
    , 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

    Reply With Quote Reply With Quote
  3. 07-07-2007 #3
    debasisdas
    debasisdas is offline
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074
    Send a message via ICQ to debasisdas Send a message via AIM to debasisdas I want to see the table details

    Re: I want to see the table details

    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.

    Reply With Quote Reply With Quote
  4. 07-12-2007 #4
    Saleem Shaik
    Saleem Shaik is offline
    Junior Member
    Join Date
    Jul 2007
    Answers
    1

    Re: I want to see the table details

    Helo,

    If u want to see the details of the table.
    Select * from
    5. ;

    Thnx
    Saleem

    Reply With Quote Reply With Quote
  5. 07-12-2007 #5
    debasisdas
    debasisdas is offline
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074
    Send a message via ICQ to debasisdas Send a message via AIM to debasisdas I want to see the table details

    Re: I want to see the table details

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

    Reply With Quote Reply With Quote
    6. « Previous Thread | Next Thread »

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •  

    Forum Rules

    About us
    Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
    GeekInterview
    Interact