-- create procedure command CREATE PROC PROC_CREATE_TABLE @TABLE_NAME VARCHAR(50), @FIELDS_LIST VARCHAR(50) AS BEGIN DECLARE @QUERY VARCHAR(8000) SET @QUERY = ' CREATE TABLE '+@TABLE_NAME+'( '+@FIELDS_LIST+')' PRINT(@QUERY) EXECUTE(@QUERY) EXEC SP_COLUMNS @TABLE_NAME END -- execute the procedure providing the parameters EXEC PROC_CREATE_TABLE @TABLE_NAME='FIRST_DYNAMIC_TABLE', @FIELDS_LIST='FIELD_1 INT, FIELD_2 VARCHAR(10) ' -- check you new table SELECT * FROM FIRST_DYNAMIC_TABLE