SQLTool conform SQL-99 and SQL-2003
2 posters
Page 1 of 1
SQLTool conform SQL-99 and SQL-2003
Hello everyone,
So I didn't quite know if it's OK to post this in here, so I apologize in advance in case I've posted in the wrong section.
I am searching for a database designer tool that uses the SQL-99 and SQL-2003 standard.
Any suggestions ?
So I didn't quite know if it's OK to post this in here, so I apologize in advance in case I've posted in the wrong section.
I am searching for a database designer tool that uses the SQL-99 and SQL-2003 standard.
Any suggestions ?
ObjectiveC- Posts : 25
Join date : 2011-03-18
Re: SQLTool conform SQL-99 and SQL-2003
Not sure what you mean by a designer tool. If you are referring to schema generation, DDL hasn't changed much (it at all). Besides, the physical model is intimately tied to the particular database vendor and version such that the SQL standards version is the least of your concerns.
If you mean a query/reporting tool, most all support the newer join syntax as well as the analytic functions. Also, most tools allow you to code your own column expressions, allowing you to leverage any features your database supports.
If you mean a query/reporting tool, most all support the newer join syntax as well as the analytic functions. Also, most tools allow you to code your own column expressions, allowing you to leverage any features your database supports.
Re: SQLTool conform SQL-99 and SQL-2003
Hello ngalemmo,
I definitely mean schema generation.
I'm trying out SQL Power Architect at the moment. What I'll try to do is add the proper JDBC driver to use the tool. I'm hoping that will do the trick.
Will let you know.
I definitely mean schema generation.
I'm trying out SQL Power Architect at the moment. What I'll try to do is add the proper JDBC driver to use the tool. I'm hoping that will do the trick.
Will let you know.
ObjectiveC- Posts : 25
Join date : 2011-03-18
Re: SQLTool conform SQL-99 and SQL-2003
So I've tried the tool SQL Power Architect out and it works nicely. Unfortunately itīs not able to generate the proper DDL for my database LucidDB.
This is concerning Foreign keys:
ERROR:
Does anyone here have experience with LucidDB and if so, which tools do you use ?
This is concerning Foreign keys:
- Code:
ALTER TABLE <table> ADD CONSTRAINT <dimension>_fk
FOREIGN KEY (<dimension>_key)
REFERENCES <dimension> (<dimension>_key)
ON DELETE NO ACTION
ON UPDATE NO ACTION;
ERROR:
- Code:
[ALTER - 0 row(s), 0.000 secs] org.eigenbase.sql.parser.SqlParseException: Encountered "CONSTRAINT" at line 1, column 33.
Was expecting one of:
"COLUMN" ...
<IDENTIFIER> ...
<QUOTED_IDENTIFIER> ...
<UNICODE_QUOTED_IDENTIFIER> ...
Does anyone here have experience with LucidDB and if so, which tools do you use ?
ObjectiveC- Posts : 25
Join date : 2011-03-18
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|