CREATE TABLE SalesHistory (SaleID int IDENTITY(1,1) NOT NULL, ProductID TINYINT, CustomerID INT, ... You can use cascading constraints in SQL Server to set related values to NULL, ...

SQL Server 2008 introduces the ability to pass a table data type into ... The following script will create the table in the database of ... reduce server round trips, use table constraints, ...

How to Create a Table From Query Results in Microsoft SQL. If your business uses relational databases to store data, you may have used a SQL SELECT clause to create new tables from query results.