Sql Table Creation




Follow SANGITAB Blog With Bloglovin

To Get Regular Updates on Facebook

Like Our Facebook Page

Sql Table Creation

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


Follow

More From Our Site:

No comments


About Us | HTML to XML Converter | Webmail Service | Nepali Unicode | Advertise | TC & Privacy Policy | Contact Us | DMCA.com Protection Status