Create table using t-sql in sql server 2008

Go down

Create table using t-sql in sql server 2008

Post by Admin on Thu Feb 20, 2014 4:01 pm

Creating tables in t-sql is very simple, so today I want to give an example on how to create a table in sql server using t-sql. It is best practice to create different files and filegroups to split your tables when you know that you will have very large tables.

CREATE TABLE DBINTSQL
(
  DBID int IDENTITY (1,1) PRIMARY KEY,
  FirstName Varchar (25),
  LastName Varchar (35),
  Email Varchar (200),
  PhoneNumber Varchar(12)
)
on TBFILE

Just like that you have a table created.
avatar
Admin
Admin

Posts : 9
Join date : 2013-10-16
Age : 33

View user profile http://forensicsblog.forumotion.com

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum