removed implicit nulls
formatting
mssql index
some fixes for createTableQuery