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 |
|
MPEvans
Starting Member
7 Posts |
 Posted - 2006-03-30 : 03:52:20
|
| Are there any formal standards published (eg by Microsoft) for naming of tables, fields, fk fields, sps, etc in a SQL Database?If not, what do you use?Thanks,Martin |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-03-30 : 04:37:21
|
Also, It is better to avoid space, numeric values as object names, although you are allowed to do so. Otherwise you cant avoid this type of queries  create table [ ] (i int)select * from [ ]create table [1]([2] int, [3] int, [4] datetime)select * from [1] where [2]>3 and [4]>getdate()Drop table [ ]Drop table [1] MadhivananFailing to plan is Planning to fail |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-03-30 : 04:39:30
|
Good illustration. Madhivanan 
KHChoice is an illusion, created between those with power, and those without.Concordantly, while your first question may be the most pertinent, you may or may not realize it is also the most irrelevant |
|
|
|
|
|
|
|
|
Standards