Hi,
What is the equivalent of DISPLAY STRUCTURE for an access or MS SQL database ?
Thanks .
DISPLAY STRUCTURE with SQL
- Rick Lipkin
- Posts: 2397
- Joined: Fri Oct 07, 2005 1:50 pm
- Location: Columbia, South Carolina USA
Re: DISPLAY STRUCTURE with SQL
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
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
Re: DISPLAY STRUCTURE with SQL
Hi Jack,
you could try:
or
Regards
you could try:
Code: Select all
select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='tableName'
Code: Select all
sp_columns '<table name>'
Re: DISPLAY STRUCTURE with SQL
Code: Select all
sp_help '<TableName>'
Re: DISPLAY STRUCTURE with SQL
Thanks
This code works good !
select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='tableName'
This code works good !
select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='tableName'