469,612 Members | 1,616 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,612 developers. It's quick & easy.

Looking for MSSQL table structure

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

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
  7. -- 
  8. -- Current Database: dcfydllc
  9. -- 
  11. CREATE DATABASE /*!32312 IF NOT EXISTS*/ dcfydllc;
  13. USE dcfydllc;
  15. -- 
  16. -- Table structure for table `apphist`
  17. -- 
  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
0 7796

Post your reply

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

Similar topics

14 posts views Thread by Andre | last post: by
5 posts views Thread by Bradley.. .. . . .. .. | last post: by
14 posts views Thread by Kukurydz | last post: by
2 posts views Thread by Jeremy Cowles | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.