RE: dbschema

Are there any SQL Server gurus that can help me out? I am looking for the store procedure in SQL Server that does something similar to the dbschema command. I thought it was sp_helpdb, but that is not giving me what I want. Sorry in advance for this post on the Informix listing. Larry

Sp_helptext will work for some objects ... http://msdn.microsoft.com/en-us/library/ms176112.aspx -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LARRY SORENSEN Sent: Friday, September 26, 2008 11:23 AM To: ids@iiug.org Subject: RE: dbschema [13505] Are there any SQL Server gurus that can help me out? I am looking for the store procedure in SQL Server that does something similar to the dbschemacommand. I thought it was sp_helpdb, but that is not giving me what I want. Sorry in advance for this post on the Informix listing. Larry ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

You can use sp_help <tablename> or You can use Enterprise Manager for SS2000 to script out or You can use Management Studio for SS2005/SS2008 to script out. Sorry about answering SS questions.  Before printing this e-mail, think if it is necessary. Think Green. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LARRY SORENSEN Sent: Friday, September 26, 2008 12:23 PM To: ids@iiug.org Subject: RE: dbschema [13505] Are there any SQL Server gurus that can help me out? I am looking for the store procedure in SQL Server that does something similar to the dbschema command. I thought it was sp_helpdb, but that is not giving me what I want. Sorry in advance for this post on the Informix listing. Larry ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ***** Jackson Hewitt Email Disclaimer ***** The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments. Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email.