[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.
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
a
anonymous
said
almost 13 years ago
[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.
anonymous