Flex Wiki Sql Schema

Enter a topic name to show or a new topic name to create; then press Enter

.

AMoreRecentAuthorsNote

Okay - the download link has been permanently fixed. Enjoy!

AuthorsNote

Sorry! This topic has existed for probably almost a year and I never realized that the source code was inaccessible! I will be correct it in the near future (and uploading V2 of fwSqlSchema once it's ready - it's been through a major overhaul). --ErikD

The purpose of this plugin is to provide extended information about the structure (and content!) of a SQL Server database.

Download the source here (Yeah, yeah, it's not very well written, and I never resolved the "

 bug when displaying stored proc contents, but at least it won't crash. ;-) )

Plugin methods that are callable from WikiTalk are:

String AnalyzeStoredProcedure(String dbName, String procName)

String AnalyzeTable(String dbName, String tableName)

String DefinitionOfStoredProcedure(String dbName, String procName)

String ListColumnProperties(String dbName, String tableName, String colName)

String ListDatabases

String ListDistinctColumnValues(String dbName, String tableName, String colName)

String ListStoredProcedures(String dbName)

String ListTables(String dbName)

String TableOfData(String dbName, String tableName)

Sorry, documentation is sparse, but I can warn you that there are @private

InterWiki("ants", "const", "const")@@ that will require modification at the beginning of fwSqlSchema.cs. AQuestion: Hi, I need to pull data out of a database into my wiki. Is that what this topic is about? The page you reference above for downloading the source requires a username and password. Thanks. TheAnswer: This plugin indeed supports retrieving data from database tables, although I wouldn't suggest trying it for tables that contain more than 8 columns X 25 rows or so... as for the Jot problem, see the AuthorsNote at the beginning of this topic.