Tag Archives: table

Tables in Sql Server stores data in the form of Rows and columns. Below is the basic syntax for creating Table in Sql Server. CREATE TABLE <TableName> ( <ColumnName1> <Datatype> [CONSTRAINT], <ColumnName2> <Datatype> [CONSTRAINT], . . <ColumnNameN> <Datatype> [CONSTRAINT] ) Example: CREATE TABLE Customer ( CustomerId INT NOT NULL, Name NVARCHAR(100) NOT NULL, PhoneNumber VARCHAR(15)Continue reading “TABLE”