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, 2535🔥, 0💬