General MySQL Oracle SQL Server

CREATE TABLE - Creating New Tables in SQL Server

Q

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

✍: FYIcenter.com

A

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.

 

⇒ "sys.tables" - Getting a List of All Tables in SQL Server

⇐ DDL (Data Definition Language) Statements for Tables? in SQL Server

⇑ Managing Tables and Columns in SQL Server

⇑⇑ SQL Server Database Tutorials

2016-11-17, 3951🔥, 0💬

General MySQL Oracle SQL Server