Sql Table Creation

ADVERTISEMENT

---

Table in Sql server is the primary object of database. All the information of our data are store in the form of
table which is the collection of data, with various rules and keys
Syntax:

Create table <tablename>
(
columnname datatype,
columnname datatype
)

Here I am creating the sample table as tblCategory you can rename and change the column name of the table

CREATE TABLE [dbo].[tblCategory](
[intcategoryid] [int] NULL,
[categoryname] [nvarchar](50) NULL,
[isActive] [bit] NULL
) ON [PRIMARY]
GO