Create table using t-sql in sql server 2008

[Admin]

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.