SQL script for created VIEW in database wrong?
Posted: Wed 06 Jul 2011 15:24
Hello,
I created a simple database (SQLite) with a Table and a View. For the View I used the following script:
If I import my database, I can see the table and the view in the “Database Explorer” which is separated in two categories:
Database Connection --> main --> Tables --> Product
Database Connection --> main --> Views --> ProductSlim
If I try the function “Generate Database Script From Model” I see that my View is converted to a table:
Is there any possibility to avoid this conversion?
regards
Peter Kuhn
I created a simple database (SQLite) with a Table and a View. For the View I used the following script:
Code: Select all
CREATE VIEW ProductSlim AS
SELECT ID, Name FROM Product
Database Connection --> main --> Tables --> Product
Database Connection --> main --> Views --> ProductSlim
If I try the function “Generate Database Script From Model” I see that my View is converted to a table:
Code: Select all
--
-- Creating a table "main".ProductSlim
--
CREATE TABLE "main".ProductSlim (
ID INTEGER,
Name TEXT
);
regards
Peter Kuhn