Читаем матчасть - ArcSDE Command Reference:
sdetable -o create_view -T <view_name> -t <table1,table2...tablen>
-c <table_col1,table_col2...table_coln>
[-a <view_col1,view_col2...view_coln>] [-w <"where_clause">]
[-i <service>] [-s <server_name>] [-D <database>]
-u <DB_User_name> [-p <DB_User_password>] [-N] [-q]
Views can be created with the "create_view" operation. The views created are stored in your DBMS just like any other view you would create with an SQL editor. You may create views that join several tables together up to the limit imposed by your DBMS. However, just as ArcSDE imposes the limit of one spatial column per table, that limit also applies to views created by the "create_view" operation.
Note when a view is created from multiple base tables, and as a result more than one rowid column exists, ArcSDE uses the first rowid column in the attribute list. It is important that this row id column does not contain duplicate values of NULL values as a result of the query used to create the view. If it does, querying the view will become unpredictable.