Jedak (1/25/2010)

---

For SQL Server I, prefix the following items in my T-SQL.

1. Stored procedures

2. Views

3. Indexes

4. Constraints

5. Keys

6. Defaults

I do it for two reasons.

1. It's the office standard.

2. I feel...

While this doesn't invalidate any points made about archaic prefixing practices in people use in DBs, maybe you would be interested in this tidbit on Hungarian Notation...

http://www.joelonsoftware.com/articles/Wrong.html

If you...