How to create a stored procedure where the parameter will be the table name?

Question

SQL

I'm trying to create a stored procedure in which the name of the created table is set as a parameter. Tried initially like this (because the name is a unique number):

CREATE PROCEDURE createTableFact
  (
    @name int
  )
AS
CREATE TABLE @name (id int not null IDENTITY (1,1), products varchar(max), weight int, boxes int, suma int, total int)

But it cursed at @name (Incorrect syntax near "@name". Expected ".", ID, or QOUTED_ID.)
Changed to this:

CREATE PROCEDURE createTableFact
  (
    @name varchar(max)
  )
AS
CREATE TABLE @name (id int not null IDENTITY (1,1), products varchar(max), weight int, boxes int, suma int, total int)

The problem hasn't been resolved.
I decided to create a table through an SQL query in the program itself (I write in c # using SqlConnection)

cmd.CommandText = "CREATE TABLE "+affected+" (id int not null IDENTITY (1,1), products varchar(max), weight int, boxes int, suma int, total int)";

Where affected is an int variable with that name and an assigned number.
In principle, he eats it, but returns an error where he does not like the number.
Tried to convert to String - same effect.
Already all the head broke how to do it?

Answer 1

The idea smacks of insanity, so I want to learn more about the idea and business logic, why all this. And there is a
solution

Answer 2

You can create a query dynamically and execute it

DECLARE @sql NVARCHAR(max)=''
SELECT @sql = ' CREATE TABLE '[email protected] + ...
Exec Sp_executesql @sql