Results 1 to 15 of 15

Thread: How to view the structure of the table

  1. #1

    How to view the structure of the table

    How to view the structure of the table in SQL Server
    What is the latest version of SQL Server 2000


  2. #2
    Junior Member
    Join Date
    Apr 2006
    Answers
    3

    Re: How to view the structure of the table

    sp_help

    is used to view table structure

    latest version of SQL SERVER 2000 is SQL Server 2005


  3. #3
    Junior Member
    Join Date
    Dec 2005
    Answers
    1

    Smile Re: How to view the structure of the table

    type and highlight the table name in query analyzer and do alt+F1


  4. #4
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: How to view the structure of the table

    till date latest version of SQL SERVER is version 2005.


  5. #5
    Junior Member
    Join Date
    Jul 2007
    Answers
    1

    Re: How to view the structure of the table

    write view name in from clause.


  6. #6
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: How to view the structure of the table

    dear pandyaudit

    please go through the original question and try to understand it before posting. Here the user asking for the structure not for data ,cwhich has already been answered. Be careful regarding this in future post.

    MODERATOR


  7. #7
    Contributing Member
    Join Date
    Feb 2007
    Answers
    34

    Re: How to view the structure of the table

    Hi subashini,
    For SQL 2000 server you can view all the diagrams of tables.Go to Enterprise Manager, find the database, find the table then click on table diagram. Hope you u will get it. And MS SLQ 2005 is the latest from Microsoft.

    Thanks & Regards,
    M.A.Raafay.


  8. #8
    Junior Member
    Join Date
    Aug 2007
    Answers
    7

    Re: How to view the structure of the table

    using SP_HELP we can get it all the informations about the table..


  9. #9
    Junior Member
    Join Date
    Aug 2007
    Answers
    1

    Re: How to view the structure of the table

    select * from (if we want 2 see the total data& structure of the table)
    select ...from
    where (if selected item)


  10. #10
    Junior Member
    Join Date
    Apr 2007
    Answers
    6

    Re: How to view the structure of the table

    sp_help
  11. will help you to get the table structure


  12. #11
    Junior Member
    Join Date
    Feb 2007
    Answers
    26

    Re: How to view the structure of the table

    hey will
    desc table_name not help this out?


  13. #12
    Junior Member
    Join Date
    Aug 2007
    Answers
    7

    Re: How to view the structure of the table

    You see the table structure using SP_HELP..

    sp_help table_name


  14. #13

    Re: How to view the structure of the table

    my friends is it work?

    desc


  15. #14
    Junior Member
    Join Date
    Apr 2007
    Answers
    1

    Re: How to view the structure of the table

    Quote Originally Posted by Subashini.Ramasamy View Post
    How to view the structure of the table in SQL Server
    What is the latest version of SQL Server 2000
    exec SP_help



  16. #15
    Junior Member
    Join Date
    Sep 2007
    Answers
    10

    Re: How to view the structure of the table

    There are three levels in a DBMS i.e SQL
    a) External
    b)Conceptual
    c)Internal

    I guess ur question might be related to second level i.e conceptual.
    For that u can do one thing
    type this query
    select *from tablename

    or
    ur question might be related to third level i.e internal
    for that u can take the help to sql tool Enterprise Manager


    Latest version of sql : SQL Server 2005


  17. Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •  
    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.
    Interact