How should I name variables in the SQL language?

Asked

Viewed 104 times

0

Is there any pattern of naming variables in SQL? I want to define the most standardized possible,for the following cases:

  • Appointment of the database
  • Table nomination
  • Naming of columns
  • Appointment of CONSTRAINS

Is there an ANSI that reports this?

  • 1

    I’ve never heard of any kind of ISO or ANSI standard about such a nomenclature standard. I’ve always seen such a pattern as something internal to every organization.

  • I found a style guide to help with these default questions: https://about.gitlab.com/handbook/business-ops/data-team/sql-style-guide/

  • 2

    In my opinion, the tip is: If you started with a pattern, finish with it. Generally, several frameworks have naming patterns, but each uses one way. That’s why the most important thing is to define a rule not to get messy and not invent fashion in the middle of the road.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.