How would you display via an SQL statement, using Access 2003 with an MDB type file, a table structure for table tblTest?

Posted on 2011-04-28
Last Modified: 2012-08-14
How would you display via an SQL statement, using Access 2003 with an MDB type file, the table structure for table tblTest so that I could see the table layout?
Question by:zimmer9
    LVL 16

    Expert Comment

    by:Bryan Butler
    As in "describe tblTest"?

    Author Comment

    I think "Describe" works for SQL Server but not for Access mdb type files.
    LVL 16

    Expert Comment

    by:Bryan Butler
    If there's not a describe command, you could do it in a script:
    LVL 16

    Accepted Solution

    oh, there's not a describe.  How about that scipt?  Will that work for you?
    LVL 5

    Expert Comment

    Direct sql syntax "sp_columns @table_name=[tablename]"

    How do you want to view the layout as in to what medium do you want to display it too ?

    1. Program to display to some window
    2. Write to some sort of file
    3. Pop out a message window


    using MSACCESS only without and SQL statement it has a function to show you the table design
    by going into the database (MDB/XXX) right click the table and click design view...


    using MSSMS ( Microsoft SQL Studio Management Studio ) **but this wouldnt be a MDB file but rather a sql server database and following pretty much the same route...***

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now