http://users.pandora.be/pecop/sqlr/sqlbasics.html
using that i have tried to get table makeup dumped only to get what looks like rubbish as wraps at 60 characters no matter what making it nearly impossible to figure out from the output.
I have been hoping to find something like MySQL's mysqldump so that i can read the table creation part of the outputs and know how the tables are set up AND have a backup (which would be useful and i dont belive we currently have)
Any pointers to a tool like this or in how to get mssql to give me output usable like this would be deeply appreciated.
There was a GUI interface that had an expired trial when i was given the job of taking over. I would have to get approval before getting anything I need to pay money for.
The type of print out I am looking for wouldbe something like this from MySQL for a previous thing I had done (previous to this job even)
Expand|Select|Wrap|Line Numbers
- -- MySQL dump 8.23
- --
- -- Host: localhost Database: dcfydllc
- ---------------------------------------------------------
- -- Server version 3.23.58
- --
- -- Current Database: dcfydllc
- --
- CREATE DATABASE /*!32312 IF NOT EXISTS*/ dcfydllc;
- USE dcfydllc;
- --
- -- Table structure for table `apphist`
- --
- CREATE TABLE apphist (
- appindex int(10) unsigned NOT NULL auto_increment,
- aid int(10) unsigned NOT NULL default '0',
- uid int(10) unsigned NOT NULL default '0',
- item tinyint(1) NOT NULL default '0',
- reason tinytext,
- ok tinyint(1) NOT NULL default '0',
- appdate datetime NOT NULL default '0000-00-00 00:00:00',
- PRIMARY KEY (appindex),
- KEY item (item),
- KEY ok (ok),
- KEY appdate (appdate),
- KEY uid (uid),
- KEY aid (aid)
- ) TYPE=MyISAM;
-Josh Perlmutter