Info, Tutorials, Downloads, Audio Books, Videos, Ebooks and More

Tuesday, July 11, 2017

Sql Table Creation

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

Recommended Articles :

No comments:

Post a Comment

Dear Readers,

Great !! You've decided to leave comment for us. Let's make meaningful conversation by adding your name.

Please note that,

Comments deemed to be spam or questionable spam, including profanity and containing language or concepts that could be deemed offensive will be deleted.
Including a link to relevant content is permitted, but comments should be relevant to the post topic.