Create database objects using SQL

 

---- No constraints are set.
If object_id ('df _ hrm_empkaoqin_fjiaqinlx ') is null
Alter table hrm_empkaoqin add Constraint
Df_hrm_empkaoqin_fjiaqinlx default (0) for fjiaqinlx
 
--- Change field type
Alter table hrm_empkaoqin alter column fbeizhu varchar (1600)
 

-- The field cannot be blank.
Alter table sto_mcoh_inkey alter column fpihao varchar (30) not null

-- Add a field
If not exists (
Select *
From syscolumns
Where id = object_id ('table name') and name = 'field name ')
Alter table table name add field name varchar (100)

-- Delete a temporary table
If object_id (N 'tempdb .. # TMP ', N 'U') is not null
Drop table # TMP