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, 2684🔥, 0💬
Popular Posts:
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...