Hi,
Does anyone know how i can AutiFix (ie check that all tables and primary keys are setup) an SQL database?
A company i was working for a few years ago had this facility on their software and i was really handy.
Daniel.
Hi,
Does anyone know how i can AutiFix (ie check that all tables and primary keys are setup) an SQL database?
A company i was working for a few years ago had this facility on their software and i was really handy.
Daniel.
You can't autofix a database, here or in the moon.
In SQl you can make a select to gather all the info you mention: Tablas, index on this tables... all depend on the database you use... for FireBird, i have some examples, but you can find them easily googling too.
Here i collect all of them:
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.