What are user defined datatypes and when you should go for
them?
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
Can we perform backup restore operation on tempdb? : sql server database administration
Can we use pragma autonomous_transaction in trigger?
Explain syntax for viewing trigger?
What is the purpose of grouping data in a report?
What are the two modes of authentication in sql server?
How to list all tables in the database using odbc_tables()?
What are the features of Embedded SQL
What are the differences between local and global temporary tables?
How to download and install microsoft .net framework version 2.0?
what information is maintained within the msdb database? : Sql server administration
How to list all objects in a given schema?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
What is a result set object returned by mssql_query()?
How many categories of data types used by sql server?
What happens to a statement batch if there is a compilation error?