| 1234567891011121314151617181920212223 |
- #
- # see http://schemaspy.sourceforge.net/dbtypes.html
- # for configuration / customization details
- #
- description=Microsoft SQL Server
- connectionSpec=jdbc:microsoft:sqlserver://<host>:<port>;databaseName=<db>
- host=database server host
- port=database port on host
- db=database name
- driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
- # Sample path to the sql server drivers.
- # Use -dp to override.
- driverPath=C:/Program Files/Microsoft SQL Server 2000 Driver for JDBC/lib/msbase.jar;C:/Program Files/Microsoft SQL Server 2000 Driver for JDBC/lib/mssqlserver.jar;C:/Program Files/Microsoft SQL Server 2000 Driver for JDBC/lib/msutil.jar
- # return text that represents a specific :view / :schema
- selectViewSql=select text from syscomments sc, sysobjects so where sc.id=so.id and so.name=:table
- # return table_name, column_name, comments for a specific :schema
- selectColumnCommentsSql=SELECT i_s.TABLE_NAME, i_s.COLUMN_NAME, s.value AS comments FROM INFORMATION_SCHEMA.COLUMNS i_s INNER JOIN sysproperties s ON s.id = OBJECT_ID(i_s.TABLE_SCHEMA+'.'+i_s.TABLE_NAME) AND s.smallid = i_s.ORDINAL_POSITION AND s.name = 'MS_Description' WHERE OBJECTPROPERTY(OBJECT_ID(i_s.TABLE_SCHEMA+'.'+i_s.TABLE_NAME), 'IsMsShipped')=0
|
