I 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.
========================================== 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.
========================================== 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 response it's GOOD
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 MVP http://visakhm.blogspot.com/
extract list of table and list of colum
Posted - 10/24/2012 : 03:30:16
