DB schema for columns with special characters

Creating schema for Sql database which contains special characters ( / , <, > , %, #, &, - ) or only integer in their columns

For this you have to edit the query while defining the schema by surrounding the column name having special characters with square brackets. You can also use alias name along with it.

Examples:

Name/Full Name should be written as [Name/Full Name] in query while defining schema.
Similarly for
Name < Full Name or
Name > Full Name or
Name % Full Name or
Name # Full Name or
Name - Full Name
should be written as [Name - Full Name]

Take a special care while using “ & “, it should be used as [Name &amp;Full Name] .

With Alias name:

Name/Full Name should be written as [Name/Full Name] as Name

Have more questions? Submit a request

0 Comments

Article is closed for comments.