Dropping User-Defined Types : Create Type « Data Types « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Data Types
  3. Create Type
4>
5> CREATE TYPE dbo.AccountNBR FROM char(14) NOT NULL
6> GO
1>
2> DROP TYPE dbo.AccountNBR
3> GO
1>








5.6.Create Type
5.6.1.The syntax of the CREATE TYPE statement is as follows:
5.6.2.Creating and Using User-Defined Types
5.6.3.Identifying Columns and Parameters that Use User-Defined Types
5.6.4.Now see what parameters reference the AccountNBR data type
5.6.5.Dropping User-Defined Types