7/8/2023 0 Comments Create chm![]() PRINT 'SERVER SETTINGS | DATABASE SETTINGS | USERS | TABLES | VIEWS | STORED PROCEDURES'ĪND NOT EXISTS (select 1 from master.sysdatabases WHERE name = AND (status & 4) = 4)Įxec sp_dboption ,'select into/bulkcopy', 'true' SELECT = '' + db_name() + ' Database Definition' PRINT = (SELECT FROM master.sysdatabases WHERE = db_Name()) ![]() SELECT = + '' + db_Name() + ' Database DefinitionTD.Sub' I'm pasting the script below, but i wish i could identify the person who wrote it it has helped me a lot in my documentation, and i'd like to thank them. It produces results in HTMl, and a google search showed me a lot of HTML to CHM converters Someone created a script here on SSC which creates HTML documentation of a database and it's schema You can also design your own custom tags. They are both worth their weight in gold. You can use each tag more than once and both will insert an HTMLīoth will allow you to put HTML in your text.īoth will produce Compiled help and HTML help. ![]() #PARAM produces the description of your stored procedure/function parameters. #KEYWORDS lets you create 1st and 2nd tier keyword entries in the help file index. #SEEALSO allows you to cross reference the pages created for other objects. #ISNEW Takes a date and if the global date of a project is prior to the ISNEW date then the objects in the help file get a red star to emphasise the fact that they are new. ![]() #RETURNS gets picked up under the heading of RETURNS #SUMMARY gets picked up as the object description MS_Description can be appended to other objects such as indexes and constraints using the sp_addextendedproperty stored procedure.īoth use special tags to document stored procedures, functions, views and triggers. The real name of this extended property is MS_Description. NET Assemblies, ActiveX controls VBA macros then go for DocumentX.īoth pick up the "Description" property of objects. If you want something that also does Access, Oracle and ODBC compliant sources plus. If you are only interested in SQL the Apex SQL Doc is the most detailed. Innovasys DocumentX and Apex SQL Doc both do it.
0 Comments
Leave a Reply. |