User-Defined Datatypes : sp_addtype « System Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. System Functions
  3. sp_addtype
29>
30> sp_addtype ssn, 'varchar(11)', 'NOT NULL'
31>








25.22.sp_addtype
25.22.1.sp_addtype creates your own specific datatypes, including how the SQL Server will handle NULL values.
25.22.2.User-Defined Datatypes
25.22.3.execute sp_addtype id,'varchar(11)' ,'NOT NULL'