sqlpro for mssql create table from content of another table

Default database search now uses fuzzy search - it will initialize to contains, but also include results which contain all all of the letters sequentially (similar to autocomplete).Added a keyboard shortcut to the search database tab (CTRL+F).Alias colors can now be changes via the preferences.Added a 'focus database tree' keyboard shortcut (CTRL-D).Fixed an issue with temp tables not showing up in SQL Server.Fixed an issue where the query editors theme might not switch properly with light/dark mode.Improved support for loading Postgres foreign keys.Added support for foreign key via results grid in Snowflake databases.Fixed an issue with foreign key links in the results table view.Fixed an issue with adding MySQL columns to an existing table and re-ordering/renaming columns.

Improvements for Snowflake timestamp columns (#617).Fixed an issue with MySQL foreign key links on results grid being reversed, which would cause invalid lookups (#639).Improved Snowflake database tree performance for schemas and tables.Autocomplete now includes JOIN statements for foreign keys.Improvements to primary key and foreign key caching.Timezone and timeouts can now be specified.

Added an 'Advanced' -> 'Connection settings' option to MySQL connections.

Renaming a column and adding a column was sometimes ordered incorrectly.

Fixed a crash that could occur when duplicating tables via the database tree.

Fixed a crash that could occur when pre-loading foreign keys.

Improvements for displaying errors in the query editor.

Added autocomplete/syntax highlight support for additional Snowflake functions.

Possibly fixed an issue where MySQL database tree may show Unknown version, even when the tree node was refreshed.

Fixed an issue where table detection may detect the wrong table if a comment proceeded the query.

It was slightly larger than it should be.

Fixed an issue with is null/is not null filters.

Holding option while selecting from the database tree now includes the column names.

Improvements to query formatter to use the proper indention.

Fixed a crash introduced in the last version with snowflake and oracle database tree.

Made some improvements with scripting Redshift functions.

(Affects primary/foreign key loading and editing result sets).

Fixed an issue with Postgres table detection.

Fixed an issue where Snowflake schemas may not sort properly.

Fixed an issue where editing favourites would sometimes not display proper syntax highlighting.

Added 'Script as' drop & create for MySQL trigger context menu.

Fixed an issue with editing MySQL triggers.

Fixed a crash some users could see shortly after startup.

Fixed an issue where editing Postgres results may generate invalid SQL.The old behaviour of only appearing when moused over can be enabled by unchecking Always show foreign keys in Preferences -> Appearance -> Results. Foreign key links are now shown in the results grid by default.Fixed an issue where the Display bools as true/false variable may not save/load properly.Extra logging and possible fix for a crash that could occur for some users during connection.Fixed a few issues with Postgres views.Fixed a crash that could occur when adding a foreign key to a postgres table.Fixed for a crash that could occur for some users during connection.SQLPro Studio now fully supports Apple Silicon (M1/M1 Pro/M1 Max).Oracle support has been temporary removed.

Sqlpro for mssql create table from content of another table