CODEWITHSUNDEEP
sql-servert-sql
lipi Passi
lipi Passi

Reputation: 3

database coding

Why all variables and datatypes are kept in '[]' 

CREATE TABLE [dbo].[tblExerciseMultiMailTypeStructureDetails](
[ExerciseMultiMailID] [int] NOT NULL

Upvotes: 1

Views: 113

Answers (1)

Rima
Rima

Reputation: 1455

Any name that are same as SQL Server Keywords or containing embaded space must be enclosed in double quotes("") or square brackets([]). Which words are considered as keyword varies,depending on the compatibility level to which you have set your database.

Upvotes: 2

Related Questions