Backup a table to an SQL file via SSMS (Step 5) This screenshot shows the SQL Server wizard where you can choose to export Data only, Schema only, or Schema and data.
