MSSQLServer modify table names, column names, add table columns, delete table columns, modify table column types

MSSQLServer modify table name, column name, add table column, delete table column, modify table column type, code must be convenient

--Adding table ColumnsAlter TableTestAddAddressnvarchar( -)NULL;--Delete a table columnAlter TableTestDrop columnaddress;--Modifying table column field typesAlter TableTestAlter columnAddressChar(Ten);--Modify table column field namesexecsp_rename'The table name. [Column Name]','the new column name','column'eg:execsp_rename'test.address','Address1','column';--Modify Table nameexecsp_rename'Original table name','New Table name','Object'eg:execsp_rename'Test','test1','Object';

MSSQLServer modify table names, column names, add table columns, delete table columns, modify table column types