Common SQL scripts

Add Field

Alter TableT_ldw.inspecttargetAddIsmaintargetNvarchar(1)Default '0';

 

Modify Field name

Alter TableT_ldw.inspecttargetDrop ColumnAddres;

Alter TableT_ldw.inspecttargetAddAddressNvarchar(100) NULL;

 

Modify Field Value:

UpdateT_tabledescribeSetForeigntablename='';

 

Modify Field Type:

Alter table < Table Name > Alter column < Field name > New type name ( Length )

 

Delete field:

Alter table <Table Name>Drop column <Field name>;
 

 

 

 

Create a table

Create TableT_version_columndefine

(

"ID"Nvarchar(50) Not Null,

"Tablename"Nvarchar(50) Not Null,

"Columnname"Nvarchar(50) Not Null,

"Columndatatype"Nvarchar(50) Not Null,

"Formatstyle"Nvarchar(15) Not Null,

ConstraintPk_t_version_columndefinePrimary Key ("ID")

)

 

 

Delete table

Drop TableT_version_columndefine;