List table names

I’m in the process of trying to migrate my ASPNET site to Django. All my current data is tied up in MS SQL Server on a shared host that (helpfully) doesn’t support python… I could use my existing code to export all the data but I’ve also stopped using Windows. The site is mainly compiled VB.NET so I’d need to install Windows and Visual Studio and then figure out what I’m trying to do… I don’t like that plan.

Rather than go through that headache, I’d like to use PHP to export the entire database (or a table at a time) to JSON. SimpleJSON in Python will make it ludicrously easy to import so it seems like a plan.

  • SQL Server Strange Ceiling() behavior
  • Should I Escape Single Quotes Before Sending a Value to a Parameterized Query?
  • How to Suppress the SELECT Output of a Stored Procedure called from another Stored Procedure in SQL Server?
  • Create a date with T-SQL
  • how to update the huge records chunk by chunk
  • PHP error connecting to MS SQL database using PDO_DBLIB
  • So far, so good. In PHP I’ve managed to connect to the SQL Server and perform simple queries, but I need a list of tables so I know what data I need to copy. I want all the tables because there are legacy tables from when I rewrote the site about three years ago, and I’d like to keep that data somewhere…

    So first thing: Does anybody know the SQL query for listing all tables?

    I’ve tried mssql_query('sp_tables'); but this returns a strange list:

    mydatabasename
    mydatabasename
    dbo
    dbo
    syscolumns
    syscolumns
    SYSTEM TABLE
    SYSTEM TABLE
    

    Secondly: In your opinion, would I be better off writing each table dump to its own .json file or should I keep it all together?

    Thirdly: Am I going about this the wrong way?

  • How do I add a auto_increment primary key in SQL Server database?
  • How to add multiple columns to a table and add default constraint on one of them?
  • How do I write a trigger to hash value before insert?
  • syntax error in CROSS APPLY
  • Delete data with foreign key in SQL Server table
  • DATEDIFF() to just return age with 2 decimal points
  • 3 Solutions collect form web for “List table names”

    Select table_name from information_schema.tables
    

    for any given table you can get the metadata with

    sp_help tablename
    

    You do query with :

    SHOW TABLES;
    

    (you need to select DB before this.)

    you can try this

    SELECT * FROM information_schema.tables
    
    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.