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.
-
Table design. Can I create ‘contraints’ in the graphical table-design view? I have been adding them by entering SQL.
-
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?
-
Once I have a file of SQL commands to be run against the database, how do I accomplish this?
-
How can I ensure that column descriptions (eg ‘Customer Number’) remain the same wherever they are used?
-
Has anyone created a data-dictionary system?
That’s definitely enough for now!