How to write RESERVE WORD as table column?For example if you want to write Number as table column name How do you write?

Interview Candidate
Jul 26th, 2007
4
2221

Showing Answers 1 - 4 of 4 Answers

rajakumar_na
Profile Answers by rajakumar_na

Nov 16th, 2007

Hey that is not possible. Definitely it will through an error.

Amritendra kumar
Profile Answers by Amritendra kumar

Feb 28th, 2008

You can write it no problem but you will have to use quote.
like ''Number''.

vamsikatragadda
Profile Answers by vamsikatragadda

Mar 8th, 2008

You Can do it Simply but keeping the table name in quotes

Here it goes like this

Create table "table" as select * from table_name;

and your problem is solved

enjoy