Header Ads Widget

Get Job Vacancy Notice, Download Syllabus and More Job Related.

Sql Table Creation

More Stuff

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
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

If You are going to Post a Comment, Please keep in mind that all comments are moderated and only comments that are relevant to the post topic will published. Let's have a meaningful conversation relevant to the post topic. THANK YOU. Check privacy policy HERE .

Post a Comment