Show create table in MSSQL

From: Alex Dar (alex_dar_at_mail.ru)
Date: 10/17/03 

Date: Fri, 17 Oct 2003 17:54:03 +0400

Hello All!
Does anybody know how i can retrieve information about structure of any
table in MSSQL?
For example, in MySQL i can send the query 'show create table ...'.

Regards,
Alexey.

Relevant Pages

  • Re: date problem
    ... I store a date (format mm/dd/yyyy) on MsSQL in a datetime field. ... mysql> CREATE TABLE test2; ... Query OK, ...
    (comp.lang.php)
  • Re: Trouble with $_POST data
    ... I am trying to send data from a form and insert it into a MSSQL DB. ... If I don't use the POST data and write the query explicitly, ... the SQL standard. ... It also will fail if MySQL is running in strict mode and with most other databases. ...
    (comp.lang.php)
  • Re: find_in_set in mssql?
    ... Amol. ... > i try to migrate from MySQL to MSSQL. ... > i have a query like ...
    (microsoft.public.sqlserver.server)
  • Re: SELECT and regular expression
    ... I'm not a big friend of MSSQL, but I have to do one query I've done for ... mySQL. ...
    (comp.databases.ms-sqlserver)
  • Re: Problem with SQL and Recordset
    ... This assumes that the name of the subform control on the parent form is the ... NextSuffix field from the "query" to be entered into the Suffix field on ... Dim mySQL As String ...
    (microsoft.public.access.modulesdaovba)