Search code examples
sql-serverviewabbreviation

Abbrevation of view in SQL Server

As there are many abbrevations used in SQL like

db -> database 
tbl -> table 
sp -> stored procedure 
v -> views

I found a view with the name dbo.v_x_source

Does that 'x' has any particular abbrevation?

Solution

  • While these abbreviations are pretty much standard, sql doesnt stop you from not conforming to these standards.

    You can create a table starting with sp and stuff. Your company might have its own set of rules with regards to naming sql objects; you might be able to ask someone with more experience.

    Personally, I think that was just named badly.