Ask Your Question

Clockman's profile - activity

2020-08-19 18:44:58 +0200 received badge  Notable Question (source)
2020-08-17 16:09:51 +0200 received badge  Notable Question (source)
2020-05-08 17:30:10 +0200 received badge  Famous Question (source)
2020-02-19 20:54:31 +0200 received badge  Notable Question (source)
2020-02-01 06:43:22 +0200 received badge  Popular Question (source)
2020-01-31 12:03:47 +0200 received badge  Popular Question (source)
2020-01-18 20:06:48 +0200 received badge  Popular Question (source)
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