Replace table_name with the name of the table you want to create.
Define the columns you want to include in the table, along with their data types and any constraints. For example, you might define a column with the INT data type and a NOT NULL constraint like this:
CREATE TABLE Customers( CustomerID INT NOT NULL, FirstName VARCHAR(50) NOT NULL, LastName VARCHAR(50) NOT NULL, Email VARCHAR(100) UNIQUE, Phone VARCHAR(20), Address VARCHAR(200), City VARCHAR(50), State VARCHAR(50), Zip VARCHAR(10));
In this example, the Customers table includes columns for CustomerID, FirstName, LastName, Email, Phone, Address, City, State, and Zip.
Execute the query by clicking on the "Execute" button in the toolbar or by pressing F5.
Your new table should now be created in the database. You can verify this by expanding the Tables folder in the Object Explorer and looking for your table.
Note that you may need to adjust the data types and constraints you use based on your specific needs and the data you plan to store in the table.