Ask Your Question

Clockman's profile - activity

2018-02-11 20:40:25 +0200 received badge  Famous Question (source)
2017-04-18 16:48:22 +0200 marked best answer Database design, table design-view, constraints etc, SQL

I've done a lot of database design but always with the advantage of using a data-dictionary system to generate the SQL to create the elements of the database, so I wanr to check that I am going down the right route. I am using WIndows 10 (64bit) and a local database.

  1. Table design. Can I create 'contraints' in the graphical table-design view? I have been adding them by entering SQL.

  2. Database structure SQL. I found the command "script , 'filename';" to extract details of everything in a database, including the data. Is there a version of this command to extract just the definitions of particular tables?

  3. Once I have a file of SQL commands to be run against the database, how do I accomplish this?

  4. How can I ensure that column descriptions (eg 'Customer Number') remain the same wherever they are used?

  5. Has anyone created a data-dictionary system?

That's definitely enough for now!

2017-04-18 16:48:21 +0200 received badge  Scholar (source)
2017-04-18 16:46:04 +0200 received badge  Notable Question (source)
2017-04-10 14:05:09 +0200 commented answer Database design, table design-view, constraints etc, SQL

Thanks for that. I was thinking that LibreOffice Base was more like Microsoft Access than it actually is, and that was

2017-04-06 02:38:21 +0200 received badge  Popular Question (source)
2017-04-05 15:21:11 +0200 asked a question Database design, table design-view, constraints etc, SQL

Database design, table design-view, constraints etc, SQL I've done a lot of database design but always with the advantag