SqlDbx
You are not logged in.
The new data types date,time(n),datetime2(n),datetimeoffset(n) still show up as nvarchar in the result grid (Show Column Types option).
Table column panel and scripting both OK though.
Offline
That is dependent on what SQL Server driver loaded.
Make sure that Tools->Options->Microsoft SQL Server->Driver Load Order looks like this:
SQL Server Native Client, SQL Server
Offline
Spot-on. Removed "10.0" from the first one and it works fine now.
Thx!
Offline
Took a closer look, the results are not quite correct yet: the time precision is not shown
e.g. select cast(getdate() as time(3)) shows TIME instead of TIME(3)
time, datetime2 and datetimeoffset should show precision, but "(7)" is optional ("time" is short for time(7), not time(0))
This is not important for column headers, but R-click > Generate > Create table has the same problem...
(sqldbx 4.2, driver load order=SQL Server Native Client, SQL Server)
Offline
Your are correct. Header shows just basic type and Generate->Create will use just this basic information.
The correct information only available when you script create for tables.
Offline