MSSQL%20Interview%20Questions%20and%20Answers

Question: How to create new tables with "CREATE TABLE" statements in MS SQL Server?

Answer: If you want to create a new table, you can use the "CREATE TABLE" statement. The following tutorial script shows you how to create a table called "tip":

CREATE TABLE wb (id INTEGER PRIMARY KEY,
subject VARCHAR(80) NOT NULL,
description VARCHAR(256) NOT NULL,
create_date DATETIME NULL)
GO

This scripts creates a testing table called "wb" with 4 columns in the current database.