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?

I use:-

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.