Start a new topic

Create Table form is modal

[This topic is migrated from our old forums. The original author name has been removed]

I've just noticed that the Create Table dialog is a modal form, preventing browsing of other objects whilst creating a new table. This isn't ideal if you want to refer to fields in other tables to determine required field sizes, types, naming conventions, etc. I may be missing something but I can't see a good reason to prevent browsing of existing objects whilst designing a new one.

[This reply is migrated from our old forums.]

Re: Create Table form is modal
Hi, We have discussed making the dialog non-modal and will probably do this, or something else that describes the problem you describe, in a future release along with other usability changes. I have added you vote for it. Best Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: Create Table form is modal
That dialog could also do with being more keyboard-friendly. If I press ENTER on the last column of the row, I'd expect to to make a new row, not jump back to the first column. I know I can use CTRL-I to add a new row but that's far less intuitive. If I enter VARCHAR(255) as a data type, I'd expect it to parse it into the Data Type and Size columns, not generate an error message. This one is a duplicate issue I've mentioned before but I mention it again as I still find it gets me nearly every time. If I type VARCHAR into the Data Type column and then press TAB I'd expect it to jump to the Size column. At present I have to press ENTER before I can TAB to the next column. The default schema for my connection should be selected when the dialog is first opened. At the moment I have to select the blank schema and scroll down quite a way to find dbo. The Execute button does what it says on the tin but it would be handy to have an "Export to SQL" button too so that I can create the same table on several databases (e.g. live, test and development versions) or customise the SQL by hand before the table is created.