All geek questions in one place

Database table name prefix

I noticed that many companies use the prefix for their database tables. For example. tables will be called MS_Order, MS_User, etc. Is there a good reason for this?

The only reason I can think of is to avoid name clashes. But is this really happening? Do people run multiple applications in the same database? Is there any other reason?

+3
source share
9 answers

In SQL Server 2005 and later, the schema function eliminates the need for any prefix. A good example of their use can be found by reading about Schemes in AdventureWorks .

SQL- .

, .

+1

. , , intellisense, MS_.:) .

+3

, . , "" .

Darn, : -)

+2

, . , , cutomer, cust_, , , inv_ ( ), , , fin_ ..

+1

, , , , , .

, , , . , , , , , , . , , , , , , , .., - , - . , .

+1

, . - , , , , .

, , , -, , , , ( , , ).

0

, , . . , , , .. , .

0

- , sql , .

sql- - , . .. admin_ , - .

, . , , , , .

0

, . , Wordpress, "wp_". , , (, ).

, , .

0

Source: https://habr.com/ru/post/1713914/

More articles:


All Articles