How to view tables in sql?

Question

Hai i am a beginner of Database,

i have a .sql file which contains some tables of data, i want to know how to import them and how to view the list of tables.

presently im using the following:-

software or editor : navicat lite server : localhost. databse file format: .sql

And what database are you using? .sql files are typically scripts not datbase tables. — HLGEM, Jan 20 '11 at 14:35

score 1 · Answer 1 · answered Aug 18 '15 at 03:34

1

Maybe you can try to execute the script in sql server, then type

select * from [database_name].information_schema.tables

to view tables and relevant information.

answered Aug 18 '15 at 03:34

orangebox

11
2

score 0 · Answer 2 · answered Jan 20 '11 at 14:35

Remember that a sql file is not really a database, it is a script. You can run the script from any tool, but I'd use command line. This is navicat connected to mysql?

mysql -u username -p databasename < script.sql
password: **

And then the results can be seen using navicat or any other tool

score 0 · Answer 3 · answered Jan 20 '11 at 14:50

If the .sql file has statements such as "CREATE TABLE..." and then later on "INSERT INTO..." then the script is possibly creating the tables and inserting the data.

To allow that to happen, the tables need to not exist in the database. You can then run the script and it will create the tables and fill in the data.

If the tables do exist, you can always either delete them, or change the CREATE to an ALTER and the script should then run.

Hope that helps.

How to view tables in sql?

3 Answers3