I'm trying to create table from template code.
This template code is working:
CREATE TABLE [dbo].[Table1] ( [Field1] [int] NULL, [Field2] [float] NULL ) ON [PRIMARY]
But if I put varchar(10):
CREATE TABLE [dbo].[Table1] ( [Field1] [int] NULL, [Field2] [varchar(10)] NULL ) ON [PRIMARY]
I get error:
Msg 2715, Level 16, State 7, Line 1 Column, parameter, or variable #2: Cannot find data type varchar(10).
The data type of a column defines what value the column can hold: integer, character, money, date and time, binary, and so on.
In practical scenarios, varchar(n) is used to store variable length value as a string, here 'n' denotes the string length in bytes and it can go up to 8000 characters. Now, let's proceed further and see how we can store SQL varchar data with a string length into the column of a SQL table.
The problem are brackets []. You have to put only varchar
into brackets: [varchar](10)
Code:
CREATE TABLE [dbo].[Table1] ( [Field1] [int] NULL, [Field2] [varchar](10) NULL ) ON [PRIMARY]
Or you can also remove the brackets:
CREATE TABLE [dbo].[Table1] ( [Field1] int NULL, [Field2] varchar(10) NULL ) ON [PRIMARY]
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With