What are user defined datatypes and when you should go for
them?
- 1 Answers
- 7321 Views
- I also Faced
- E-Mail Answers
Answer Posted / swapna
User defined datatypes let you extend the base SQL Server
datatypes by providing a descriptive name, and format to
the database. Take for example, in your database, there is
a column called Flight_Num which appears in many tables. In
all these tables it should be varchar(8).
In this case you could create a user defined datatype
called Flight_num_type of varchar(8) and use it across all
your tables.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
Is there any difference between primary key and unique with the not null condition?
What is the purpose of the tempdb database?
How to insert new line characters into strings?
What are the advantages of using third-party tools?
What is sql view?
What are the different SQL Server Versions you have worked on?
How many types of functions are there in sql server?
What does nvl stand for?
What are the general features of sql server management studio? : sql server management studio
Is INSTEAD OF trigger directly applicable to Table ?
can we have a nested transaction? : Sql server database administration
What is an indice?
What happens to a statement batch if there is a compilation error?
How do you start single user mode in clustered installations?
What is the function of sql server agent windows service?
