Collections:
CREATE TABLE - Creating New Tables in SQL Server
How to create new tables with "CREATE TABLE" statements in SQL Server?
✍: FYIcenter.com
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
2016-11-17, 2285👍, 0💬
Popular Posts:
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...