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 |
|
Beaug
Starting Member
3 Posts |
 Posted - 2012-10-24 : 03:30:16
|
| HiI search extract of "Microsoft SQL Server Management Studio" the list of table and list of colums with her characteristics ( PK , Int , no Null , ...)in Excel.Thanks |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-10-24 : 04:06:32
|
| Is this a question about how query the info?Look at information_schema.columns==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Beaug
Starting Member
3 Posts |
Posted - 2012-10-24 : 05:05:58
|
quote:
Originally posted by nigelrivett
Is this a question about how query the info?Look at information_schema.columns==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy.
===========================================Thanks for responseit's GOOD |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-24 : 10:11:37
|
| if you want to see only columns of tables make sure you add a join onto information_schema.tables and filter on table_type='BASE TABLE'. Otherwise it will include view information also.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Beaug
Starting Member
3 Posts |
Posted - 2012-10-25 : 03:22:55
|
| Thanks for your responseit's OK for me |
|
|
|
|
|
|
extract list of table and list of colum