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, 2463🔥, 0💬
Popular Posts:
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...