I am modelling a sql Server DWH and would like to know if it is possible to create a custom data type (within Toad) that you can assign to attributes in an entity. I know how to create user data types in SQL server and then use them but this is not what I want to do.
An example would probably illustrate best.
I have multiple staging tables and they all have a natural key and various other text based attributes that I would like to assign the data type ***nvarchar(50)***.
I could go through every entity for each staging table, select nvarchar for each of the attributes from the drop down box, then enter again the number 50 for the length of the nvarchar but this is very time consuming.
What I want to know is:
Is it possible to copy and past nvarchar(50) from one attribute to another in the entity properties dialogue box.
If I can’t do this (I have tried I don’t think I can) can I make a custom data type in TOAD, Just in Toad, of nvarchar(50) and select that for my attribute data type (from the drop down list of data types), instead of having to manually select nvarchar, then entering a length of 50 for every attribute (two steps instead of one).
Please note I do not want/need to create a user defined data type in the database, I have no use for this data type expect that in the absence of being able to copy and paste nvarchar(50) from one attribute to another it would save me alot of time when I am creating my staging table entities in Toad ( probably half the time).