Skrevet av Emne: MS SQL Server: show tables  (Lest 2355 ganger)

ATC

  • Gjest
MS SQL Server: show tables
« på: 07. April 2009, 18:39 pm »
  • [applaud]0
  • [smite]0
  • What is the MS SQL equivalent of "show tables"?



    ATC

    • Gjest
    [Solved] MS SQL Server: show tables
    « Svar #1 på: 07. April 2009, 18:39 pm »
  • [applaud]0
  • [smite]0
  • SELECT * FROM sysobjects WHERE xtype='U';

    This shows all User tables in the current database.