The naming-convention tag has no wiki summary.
-1
votes
0answers
41 views
Why do some DBAs avoid the use of null? [duplicate]
I've noticed that some DBAs avoid using NULL for things like integer values, instead preferring to use NOT NULL DEFAULT 0.
Is there any conventional reason for this?
0
votes
0answers
64 views
MySQL Pivot Table Naming Conventions
I have some tables (users, jobs, customers) that are each tied to 'groups'. As each table is linked to 'groups', I feel inclined to call the actual group tables user_groups, job_groups and ...
0
votes
2answers
72 views
Naming foreign key columns
Now I hear that the best practice for naming foreign key columns is the name of the table and field (and maybe the function if there are multiple foreign keys to the same table), for example, a ...
1
vote
2answers
201 views
MySQL case sensitivity for table names
Why is it that different platforms (linux vs windows) does not support the same naming conventions? I'm stunned by the fact that the documentation uses file names as an excuse for this.
Yes, windows ...
1
vote
1answer
51 views
Case style of tables and field (Naming Conventions)
What is best practice for naming dbs, tables (collections) and fields among DBMSs?
I mean casing style, for example AaaBaa,aaa-bbb, aaa_bbb, AAA-BBB, aaaBbb, ...
I think if one exists it should be ...
2
votes
2answers
163 views
T-SQL Naming Standard
Is there a recommended (official or not) style from Microsoft regarding naming and casing in T-SQL?
If there isn't one from Microsoft then is there one with broad acceptance?
1
vote
0answers
85 views
Naming the parts of a supertype/subtype pattern
I am doing more extensive work with supertyping and subtyping as it solves some problems in a very useful way. In particular, I am enhancing a web application where many things need to be subject to ...
1
vote
2answers
88 views
Naming question for functions: implicit or explicit naming of grouping in function name [closed]
Requesting help with naming TSQL functions.
Existing function names (see below for table and relationship descriptions)
I currently have functions named as follows:
...
35
votes
10answers
3k views
Why do people recommend not using the name “Id” for an identity column?
I was taught not to use the name Id for the identity column of my tables, but lately I've just been using it anyways because it's simple, short, and very descriptive about what the data actually is.
...
5
votes
3answers
617 views
Plural vs Singular Table Name
How should I name my Tables when creating a new database?
Singular: Client or Plural: Clients?
2
votes
4answers
438 views
Should I use a Column naming convention or rely on column descriptions?
Frankly I am stunned that after some basic (very basic) internet searches I have not been able to find a comprehensive naming convention or guideline or SQL object and column naming.
The parallel ...
11
votes
3answers
629 views
Is table aliasing a bad practice?
I remember learning to do this in a DBMS course for Master of Information Services students. To save yourself some typing, you can type:
SELECT t1.id, t2.stuff
FROM
someTable t1
...
7
votes
8answers
1k views
Is there a reason to use extremely abbreviated table names?
We're using a database setup from a vendor's application that has horrifically hard to read database table names, and no documentation on what is stored where. I can see why one might want to ...
10
votes
3answers
1k views
Column name naming conventions and best practices
I would like some expert opinion on best practices when it comes to column naming.
The background is that according to Wikipedia, the following syntax,
SELECT ... FROM Employees JOIN Timesheets ...
1
vote
1answer
83 views
Are there any objective reasons to prefer a prefix over a suffix for an environment-specific login?
When creating environment specific logins (development, qa, staging, production, etc.) I'm faced with the choice of making the denotation a prefix or a suffix to the login name.
Examples
...
9
votes
6answers
2k views
How should I best name my timestamp fields?
When I am looking to create some timestamp fields (or other date/time style fields), what is the best way to name them? Should I just put record_timestamp?
13
votes
5answers
608 views
What standard should I follow when naming tables and views?
What standard should I follow when naming tables and views? For instance, is it a good idea to put something like tbl_ at the beginning of table names? Should I designate code/lookup tables in some ...
