sp_unbindefault removes the connection between the default and the data type of the corresponding column : sp_unbindefault « System Functions « SQL Server / T-SQL Tutorial

1.	Query
2.	Insert Delete Update
3.	Table
4.	Table Join
5.	Data Types
6.	Set Operations
7.	Constraints
8.	Subquery
9.	Aggregate Functions
10.	Date Functions
11.	Math Functions
12.	String Functions
13.	Data Convert Functions
14.	Analytical Functions
15.	Sequence Indentity
16.	View
17.	Index
18.	Cursor
19.	Database
20.	Transact SQL
21.	Procedure Function
22.	Trigger
23.	Transaction
24.	XML
25.	System Functions
26.	System Settings
27.	System Tables Views
28.	User Role
29.	CLR

SQL Server / T-SQL Tutorial » System Functions » sp_unbindefault

25.57.1.sp_unbindefault removes the connection between the default and the data type of the corresponding column

The syntax of this statement is



      CREATE DEFAULT default_name

        AS expression



sp_bindefault is used to bind the defined default value to specific columns.



11>

12> CREATE DEFAULT zip_default AS 94710

13> GO

1>

2> CREATE TYPE zip

3>   FROM CHAR(5) NOT NULL

4> GO

1>

2>

3> sp_bindefault 'zip_default', 'zip'

4>

5> 

6>

7> sp_unbindefault 'zip_default', 'zip'

8>

9> drop DEFAULT zip_default;

10>

11> drop type zip;

12> GO

25.57.sp_unbindefault
	25.57.1.	sp_unbindefault removes the connection between the default and the data type of the corresponding column

java2s.com | Contact Us | Privacy Policy

All other trademarks are property of their respective owners.