Can I read SQL Naming Conventions and Best Practices on EtoBox?

SQL Naming Conventions and Best Practices by Trần Việt Chương is a document available to read on EtoBox.

What is SQL Naming Conventions and Best Practices about?

The document outlines SQL naming conventions for tables, columns, stored procedures, functions, views, variables, parameters, triggers, indexes, primary keys, foreign keys and constraints. Tables should use PascalCase and plural names. Columns should indicate data type with suffixes like Date or Datetime. Stored procedures follow a usp_action_name convention. Functions use ufn_purpose, views use vw_purpose, and variables use camelCase. Parameters use prefixes to indicate input or output. Other objects like

Author

Trần Việt Chương

Language

EN