Fields nomenclature conventions

[lassala]

Hi!

I'm a VFP Developer, and I'm starting to develop some SQL Server stuff. In VFP Native Database, I use Microsoft conventions for field nomenclature (c to Character data type, n to numeric, t do datetime, and so forth). I'd like too know where I could find the conventions for SQL Server data types.

Does anybody can help me?

Thanks in advance

Claudio Lassala

 

[JNC73]

You can use the samen as in VFP

 

[ColinM]

Heres is some ideas about SQL naming in general.

http://vyaskn.tripod.com/object_naming.htm

 

[tlbroadbent]

Michael Hotek provides another excellent article on SQL naming conventions at

http://www.mssqlserver.com/articles/naming_conventions_p1.asp.

Terry

;-) The single biggest challenge to learning SQL programming is unlearning procedural programming. -Joe Celko

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm