472,354 Members | 2,083 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,354 software developers and data experts.

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 7877

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

Similar topics

by: Andre | last post by:
Hello Can anyone help me translate this from access so that it can work in mssql (i need to get next value, but cannot use identity as if row is deleted, another must get new next column number...
by: Bradley.. .. . . .. .. | last post by:
Requirement: managers can login and only see employee data for the department they manage and any sub-ordinate departments. The departments are in a table that defines a simple tree structure...
by: Kukurydz | last post by:
I've got such problem: My database is stored on MSSQL Server. I have to write reports for it in MSAccess. I've got a problem with creating a query which will select records from MSSQL table with...
by: Jeremy Cowles | last post by:
Disclaimer: This could be considered an ADO question, but, it really is a question of code maintenance. I have created a utility app that synchronizes MSSQL tables & stored procedures as Classes...
by: c3q8 | last post by:
I have a batch system where the user enter suppliers invoices to a batch table (SupVchBat) then selectively update certain invoice to outstanding invoice table (SupVch) and updated suppliers...
by: LizRickaby | last post by:
My client has several Access databased that they wanted converted into MSSQL to be able to access them online (excuse the pun). I added the first Access database, LenderPrograms, as a table in the...
by: ThePhenix | last post by:
Hi everybody, I have recently been doing a conversion for my boss for a access 2000 database (both front and backend) to a MSSQL backend. I finished the conversion today (as quite a lot of the...
by: Icemokka | last post by:
Hi all, We have 2 databases that are not connected to each other directly. Changes to either databases can only be done on one side. Those 2 databases are of the type MSAccess or MSSQL but with...
by: ukchat | last post by:
I.m creating a dynamic query to pull out workbooks from my database the table structure is below. Table: curricworkbooks Columns: ID, curric, assessment, topic, workbook, filename Example data...
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made but the http to https rule only works for...
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the synthesis of my design into a bitstream, not the C++...
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.