SqlServer_template

TABLE_INFO_QUERY=select TABLE_NAME, TABLE_SCHEMA, TABLE_TYPE from INFORMATION_SCHEMA.TABLES order by TABLE_NAME
COLUMN_INFO_QUERY=select COLUMN_NAME, COLUMN_DEFAULT, IS_NULLABLE, DATA_TYPE, case when exists (select * from INFORMATION_SCHEMA.KEY_COLUMN_USAGE KCU inner join INFORMATION_SCHEMA.TABLE_CONSTRAINTS TC on KCU.CONSTRAINT_NAME = TC.CONSTRAINT_NAME where KCU.TABLE_NAME = '%TABLE_NAME%' and KCU.COLUMN_NAME = C.COLUMN_NAME and TC.CONSTRAINT_TYPE = 'PRIMARY KEY') then 'YES' else 'NO' end as IS_P_KEY, CHARACTER_MAXIMUM_LENGTH from INFORMATION_SCHEMA.COLUMNS C where TABLE_NAME = '%TABLE_NAME%' order by ORDINAL_POSITION
COLUMN_INFO_QUERY.TABLE_NAME_REPLACER=%TABLE_NAME%

DRIVER_NAME=com.microsoft.sqlserver.jdbc.SQLServerDriver
CONNECTION_CHECK_SQL=select 1
SQL_COMMENT_OUT=--