How to list atributes of all tables in Query Analyzer

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi newsgroup

I need to know the properties of all tables in a given database on MSSQL
7.0. I know that there is a stored procedure with the name "sp_MShelpcolumns"
as well as another one called "sp_MSforeachtable". How can I combine these
two to get a result that looks like: tablename, columnname, datatype, size.
The result is something that I would like to copy and paste in Excel to send
it to a business analyst.

Any input is highly appreciated.

Kind regards
Gabriel
.

Relevant Pages

  • Re: Possible?
    ... Although I have the access to the database, I don't have the know-how ... to create the stored procedure. ... Prev by Date: ...
    (microsoft.public.vb.crystal)
  • Re: How to list atributes of all tables in Query Analyzer
    ... > Hi newsgroup ... > I need to know the properties of all tables in a given database on MSSQL ... Prev by Date: ...
    (microsoft.public.sqlserver.clients)
  • how do I run a .vbs file from sql
    ... I have a .vbs file located on my server the path to which is: ... how can I run this file from a stored procedure within msSQL? ... Prev by Date: ...
    (microsoft.public.sqlserver.tools)
  • Re: Finding a record in a TADOTable
    ... comming from. ... If it is already in another table in the database then ... the stored procedure will not generate any network traffic other than ... Prev by Date: ...
    (borland.public.delphi.database.ado)
  • Re: Why the performace differs?
    ... this database is accessed by only me no one is using it. ... really, this slow performance is really weared, ... I have tested it and when i run the Stored Procedure the sql server ... Prev by Date: ...
    (comp.databases.ms-sqlserver)