Generate script in SQL Server Management Studio
Here what you have to do: right click the database (not the table) and select tasks –> generate scripts Next –> select the requested table/tables (from select specific database objects) next –> click advanced –> types of data to script = schema and data next and finish