Reader Response – DB Naming Conventions Paul Writes: A couple of observations, based on the discussion so far. For me, some things that give me some initial pointers: – How does it look ‘out of the box’ ? – What does MS do? – What happens when you use the visual tools? – How do we avoid valueless annotation? For […]
Editorials
Code Naming Conventions
Reader Response – DB Naming Conventions Paul Writes: A couple of observations, based on the discussion so far. For me, some things that give me some initial pointers: – How does it look ‘out of the box’ ? – What does MS do? – What happens when you use the visual tools? – How do we avoid valueless annotation? For […]
Code Naming Conventions
Database Naming – One Last Time I had some good thoughts come through from a few readers today that I felt were helpful and touched on areas we haven’t really covered at this point. So, I’ll drop them in here without comment, and move on with the discussion about code naming conventions in the editorial section. Ken provides some thoughts […]
Foreign Key Names
Foreign Key Names Today Thomas shares his thoughts on constraint names as well as indexes: For Foreign keys I use FK_PARENTTABLE_parentcol1_parentcol2_CHILDTABLE_childcolum1_childcolumn2 Currently, we don’t have any keys more complex than 2 columns and we are well under the 128 character limit. Our child column names are usually the same as their parent’s so I’ll probably resort to some kind of […]
Naming Conventions ? Primay and Foreign Keys
Naming Conventions – Primay and Foreign Keys Hank writes in with a scenario revolving around system assigned key names. In Microsoft SQL Server you can declare constraints without providing names. In these situations, the system assigns a name on your behalf, usually part of the key looking like a GUID. There is little meaning or value in the name. The […]
Naming Conventions ? Primay and Foreign Keys
Naming Conventions – Primay and Foreign Keys Hank writes in with a scenario revolving around system assigned key names. In Microsoft SQL Server you can declare constraints without providing names. In these situations, the system assigns a name on your behalf, usually part of the key looking like a GUID. There is little meaning or value in the name. The […]
What, More Database Naming Ideas?
$$SWYNK$$ Featured Article(s) Learning MySQL with PHP – Making the Connection to MySQL This is a simple program to connect to mysql and extract information as easy as possible.how we can make a web page in PHP to connect to a MySQL database and show us the records on screen. Featured White Paper(s) Office 365 SharePoint Online – Architectural Considerations […]
Wrap Up Database Naming Conventions
Wrap Up Database Naming Conventions I thought I would close the thoughts on Database naming conventions with a few things I find helpful, and then include thoughts submitted by others. These are a few things I like to use in my naming conventions…these are ideas that I don’t simply follow blindly. I don’t mind long names for tables, views, columns, […]
Thoughts for Database Naming Conventions
Notice anything? swynk@sswug.org < Let me know what you think! Thoughts for Database Naming Conventions Today I have lots of food for thought when it comes to naming things in the Database. The meaning of data as well as the name of the data are frequent questions that have been asked. Some feel that meaning is more important than naming […]
Database Object Naming Conventions
Database Object Naming Conventions Yesterday I tossed out the question regarding the relevance of naming conventions for hardware and software services. Today I’d like to share some insights others have shared regarding naming conventions for database objects as well. Jim writes: I think the answer lies with a couple of facets to “it depends”. It first depends on how big […]