What are user defined datatypes and when you should go for
them?
- 1 Answers
- 7529 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 oracle faster than sql server?
What is the full form of dql?
What are key constraints?
What is difference between rollback immediate and with no_wait during alter database?
what is a transaction and what are acid properties? : Sql server database administration
What do you mean by cardinality?
What are ddl triggers and types of ddl trigger?
What is database replication? What are the different types of replication you can set up in sql server?
what is a transaction? : Sql server database administration
What is PROJECTION Operation?
What do you understand by a view?
Is it safe to delete log files?
How do I start and stop sql server?
What are the different types of triggers in SQL SERVER?
What is 5nf in normalization form?
