i have a page type with many properties.
i wonder if it's possible to sort properties by name istead of use "Move up" and "Move down".
You can do it directly in the database (at least in 4.6x) or programmatically (you could build a plugin, or maybe someone already has).
how can i do it directly in the database?
I have to know which page run the query .. or ... ?
Editing Property order in the database is a little bit hard core and I can only recommend it for developers.
You need to use SQL Server Management Studio and open the table tblPageDefinition for edit and adjust the FieldOrder column. Start at zero for each page type (see fkPageTypeID column) and increment by one.
Or you can install EPiCode.EditPageType module. Read more about it in the blogpost "No more mouse arm during reorganization of page-type properties" at http://epinova.no/no/Blog/episerver_blog/?BlogBeginDate=2009-04-18