| 123456789101112131415161718192021222324252627282930 |
- #
- # see http://schemaspy.sourceforge.net/dbtypes.html
- # for configuration / customization details
- #
- # Provided by Craig Boland
- description=Microsoft SQL Server 2005
- # some details in mssql.properties:
- extends=mssql
- connectionSpec=jdbc:sqlserver://<host>:<port>;databaseName=<db>
- host=database server host
- port=database port on host
- db=database name
- driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
- # Sample path to the sql server drivers.
- # Use -dp to override.
- driverPath=C:/Program Files/Microsoft SQL Server 2005 JDBC Driver/sqljdbc_1.0/enu/sqljdbc.jar
- # querying database metadata isn't thread safe with this driver.
- dbThreads=1
- # reference: http://databases.aspfaq.com/schema-tutorials/schema-how-do-i-show-the-description-property-of-a-column.html
- # return table_name, column_name, comments for a specific :schema
- # Provided by Ernest Zapata
- selectColumnCommentsSql=SELECT OBJECT_NAME(c.object_id) AS TABLE_NAME, c.name AS COLUMN_NAME, ex.value AS comments FROM sys.columns c LEFT OUTER JOIN sys.extended_properties ex ON ex.major_id = c.object_id AND ex.minor_id = c.column_id AND ex.name = 'MS_Description' WHERE OBJECTPROPERTY(c.object_id, 'IsMsShipped')=0 ORDER BY OBJECT_NAME(c.object_id), c.column_id
|
