Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
doran_doran
Posting Yak Master
179 Posts |
 Posted - 2009-10-01 : 15:58:31
|
| I have a COLUMN_NAME called "ACTION" which is a Reserved Keyword. What COLUMN_NAME would make more sense instead of ACTION?Please suggest. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-01 : 16:02:16
|
| no problem in using a reserved word as column name. you can always escape it by wrapping it within [].regarding would be a good name, that depends on your business relevance and also what data you actually store in this |
 |
|
|
doran_doran
Posting Yak Master
179 Posts |
Posted - 2009-10-01 : 16:08:09
|
| I know visakh that you can escape by using [] however my end users are not as techy like we are. That is why I am trying eliminate all the possibilities. And as well as start with clean database. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-10-03 : 04:02:47
|
quote:
Originally posted by doran_doran
I know visakh that you can escape by using [] however my end users are not as techy like we are. That is why I am trying eliminate all the possibilities. And as well as start with clean database.
What kind of action is it?Depends on it, you can name it like user_action,etcMadhivananFailing to plan is Planning to fail |
|
|
|
doran_doran
Posting Yak Master
179 Posts |
Posted - 2009-10-03 : 14:22:01
|
| Madhi, that's a good suggession. Thanks |
|
|
|
|
|
|
Replacing Field Name