Table properties 1

[Chance1234]

ok in Access i can go tools, analyse, documenter and i can get a report on a table with all its columns and field types. how do i do the same thing in SQL 2000 ?




Filmmaker, gentlemen and proffesional drinker

http://public.fotki.com/chance1234/

 

[TitleistDBA]

In Enterprise Manager right click on the table and select properties.

In query analyzer
Type sp_help [tablename]

http://www.acushnetcompany.com

 

[Chance1234]

how can i get that in a format i can print off ?

Filmmaker, gentlemen and proffesional drinker

http://public.fotki.com/chance1234/

 

[TitleistDBA]

If you run the sp_help command from query analyzer you can send the output to a file.
From the Menu select Query
Then select results to file.
Then run your query.

It will create a .rpt file that you can open in notepad or word.

http://www.acushnetcompany.com

 

[MattN]

Have you thought about linking the tables into Access then using the documenter in Access. Works for me!

Regards