Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shifis
Posting Yak Master
157 Posts |
 Posted - 2008-11-07 : 12:46:29
|
| How can I export a structure table to excel?Thanks |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2008-11-07 : 13:07:31
|
the easiest method is to just use a query to select what you want from the sys.objects, sys.Tables ,sys.Columns and then just copy and paste in excel.
Success is 10% Intelligence, 70% Determination, and 22% Stupidity.\_/ _/ _/\_/ _/\_/ _/ _/- 881 |
 |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2008-11-07 : 13:17:50
|
| sp_columns TableName will give you all the columns and their data types for the tableJim |
|
|
|
PeterNeo
Constraint Violating Yak Guru
357 Posts |
Posted - 2008-11-08 : 01:35:28
|
Export the results of EXEC sp_help <tablename> to excel"There is only one difference between a dream and an aim. A dream requires soundless sleep to see, whereas an aim requires sleepless efforts to achieve..!!" |
|
|
|
|
|
|
Export structure table to excel