FiveTech Software tech support forums

Posted: **Tue Jun 09, 2015 12:24 pm**

Hi,
What is the equivalent of DISPLAY STRUCTURE for an access or MS SQL database ?

Thanks .

Posted: **Tue Jun 09, 2015 12:49 pm**

Jack

There are several free tools for both Access and Sql Server .. Ms Access is part of MS Office professional and comes with everything you need to create databases,tables, and to print and modify structures. Ms Sql Server has its own Microsoft tools called MS Sql Studio and is part of the Database installation.

Some free tools include :

Sql Server : Toad http://www.toadworld.com/products/toad- ... fault.aspx
Access : FiveDbu designed by Antonio is good
Alex Noland has a suite of free Database tools http://www.alexnolan.net/software/mdb_viewer_plus.htm

Rick Lipkin

Posted: **Tue Jun 09, 2015 12:51 pm**

Hi Jack,

you could try:

Code: Select all

select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='tableName'

or

Code: Select all

sp_columns '<table name>'

Regards

Posted: **Tue Jun 09, 2015 12:52 pm**

Code: Select all

sp_help '<TableName>'

Posted: **Tue Jun 09, 2015 1:39 pm**

Thanks
This code works good !

select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='tableName'

FiveTech Software tech support forums

DISPLAY STRUCTURE with SQL

DISPLAY STRUCTURE with SQL

Re: DISPLAY STRUCTURE with SQL

Re: DISPLAY STRUCTURE with SQL

Re: DISPLAY STRUCTURE with SQL

Re: DISPLAY STRUCTURE with SQL