Create Views
kiers
I apologise if I've missed an obvious menu option or something, but
I'd like to use Sequel Pro to create a view and I can't figure out
how.
It says on the SP homepage that views are supported, but I can't find
anywhere in the UI that seems to allow access to them.
Would appreciate a gentle shove in the right direction.
Cheers
Kiers
Stuart Connolly
Sequel Pro supports views in the sense that it will recognise the
existence of any views within a database and display them in the table
list in a way that they are distinguishable from normal tables. The
interface however does not yet currently support the direct creation
of views by selecting which tables and columns are the basis of the
view and so the only method to create views directly within Sequel Pro
is by executing a query within the custom query view. There are
however plans to build upon and improve the current support for the
creation of database objects (tables, views, functions, etc.) in
allowing the user greater control of them, so look out for such
functionality in future versions.
If you need any help with creating views in terms of the syntax and
options available, the official MySQL documentation is very extensive
and is a good place to start:
http://dev.mysql.com/doc/refman/5.0/en/create-view.html
Thanks
--
Stuart Connolly
Sequel Pro Developer
> --~--~---------~--~----~------------~-------~--~----~
> You received this message because you are subscribed to the Google
> Groups "Sequel Pro" group.
> To post to this group, send email to seque...@googlegroups.com
> To unsubscribe from this group, send email to sequel-pro+...@googlegroups.com
> For more options, visit this group at http://groups.google.com/group/sequel-pro?hl=en
> -~----------~----~----~----~------~----~------~--~---