desc equivalent in MS SQL

sp_columns 'table_name'

MS-SQL table level backup

export:
bcp "select * from [MyDatabase].dbo.Customer " queryout "Customer.bcp" -N -S localhost -T -E

import:
bcp [MyDatabase].dbo.Customer in "Customer.bcp" -N -S localhost -T -E

Rename column name in MS-SQL

exec sp_rename 'TABLE_NAME.[ORIGINAL COLUMN_NAME]', 'NEW COLUMN_NAME', 'column'