[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 334
  • Last Modified:

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

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?
0
zimmer9
Asked:
zimmer9
  • 3
1 Solution
 
Bryan ButlerCommented:
As in "describe tblTest"?
0
 
zimmer9Author Commented:
I think "Describe" works for SQL Server but not for Access mdb type files.
0
 
Bryan ButlerCommented:
If there's not a describe command, you could do it in a script:
http://www.access-programmers.co.uk/forums/showthread.php?t=133274
0
 
Bryan ButlerCommented:
oh, there's not a describe.  How about that scipt?  Will that work for you?
0
 
Scay7Commented:
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 ?
eg:

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

or:

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...

or

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...***
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now