Answers

Question and Answer:

  Home  MS SQL Server

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

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 tip (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 "tip" with 4 columns in the current database.

 141 views

More Questions for you: