By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,766 Members | 1,252 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,766 IT Pros & Developers. It's quick & easy.

Looking for MSSQL table structure

P: 8
I've recently become the defacto DBA of two MSSQL databases at work because I am the only one with SQL experience. I have been asked to do some tasks with the databases but this requires and understanding of their structure. I cannot find anything akin to MySQL's mysqldump for mssql and have been looking for that among other help in being able to use my MySQL experience as a base for learning MSSQL. I have spent a few days (8 to 9 hours per day) searching for this and cannot find anything. the best i have found is this link
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
  1. -- MySQL dump 8.23
  2. -- 
  3. -- Host: localhost Database: dcfydllc
  4. ---------------------------------------------------------
  5. -- Server version 3.23.58
  6.  
  7. -- 
  8. -- Current Database: dcfydllc
  9. -- 
  10.  
  11. CREATE DATABASE /*!32312 IF NOT EXISTS*/ dcfydllc;
  12.  
  13. USE dcfydllc;
  14.  
  15. -- 
  16. -- Table structure for table `apphist`
  17. -- 
  18.  
  19. CREATE TABLE apphist (
  20. appindex int(10) unsigned NOT NULL auto_increment,
  21. aid int(10) unsigned NOT NULL default '0',
  22. uid int(10) unsigned NOT NULL default '0',
  23. item tinyint(1) NOT NULL default '0',
  24. reason tinytext,
  25. ok tinyint(1) NOT NULL default '0',
  26. appdate datetime NOT NULL default '0000-00-00 00:00:00',
  27. PRIMARY KEY (appindex),
  28. KEY item (item),
  29. KEY ok (ok),
  30. KEY appdate (appdate),
  31. KEY uid (uid),
  32. KEY aid (aid)
  33. ) TYPE=MyISAM; 
Thank you in advance for your time and help
-Josh Perlmutter
Apr 11 '06 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.