I agree with using Hungarian notation for objects and variables.
I would NOT use it for anything that a user might see such as a column name.
I picked up the idea of using Hungarian Notation from Ivor Horton's C++ book and it seemed like a good idea. Although aimed at variables, pointers, properties and classes there was no reason to limit it to C++, VB etc.
Are there any agreed standards for SQL objects or indeed objects in general?
Tbl_ identifies a table.
Idx_ identifies an normal index.
Pk_ identifies a primary key.
Unq_ identifies a unique key.
Vw_ identifies a view.
usp_ identifies a user (non system) stored procedure
uxp_ identifies a use (non system) extended stored procedure.
df_ identifies a default.
rl_ identifies a rule.
ty_ identifies a user defined type.
If you are going to use some form of Hungarian Notation then it has to be adopted as a standard across the organisation.